Learn R Programming

odbc (version 1.0.0)

dbConnect,OdbcDriver-method: Connect to a ODBC compatible database

Description

Connect to a ODBC compatible database

Usage

"dbConnect"(drv, dsn = NULL, ..., driver = NULL, server = NULL, database = NULL, uid = NULL, pwd = NULL, .connection_string = NULL)

Arguments

drv
an object that inherits from DBIDriver, or an existing DBIConnection object (in order to clone an existing connection).
dsn
The Data Source Name.
...
Additional ODBC keywords, these will be joined with the other arguments to form the final connection string.
driver
The ODBC driver name.
server
The server hostname.
database
The database on the server.
uid
The user identifer.
pwd
The password to use.
.connection_string
A complete connection string, useful if you are copy pasting it from another source. If this argument is used any additional arguments will be appended to this string.

Details

The connection string keywords are driver dependant. The parameters documented here are common, but some drivers may not accept them. Please see the specific driver documentation for allowed parameters, https://www.connectionstrings.com is also a useful resource of example connection strings for a variety of databases.