Connect to a ODBC compatible database
# S4 method for OdbcDriver
dbConnect(drv, dsn = NULL, ..., driver = NULL,
server = NULL, database = NULL, uid = NULL, pwd = NULL,
.connection_string = NULL)
The Data Source Name.
Additional ODBC keywords, these will be joined with the other arguments to form the final connection string.
The ODBC driver name.
The server hostname.
The database on the server.
The user identifer.
The password to use.
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.
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.