dbConnect,OdbcDriver-method {odbc} | R Documentation |
Connect to a ODBC compatible database
## S4 method for signature 'OdbcDriver' dbConnect( drv, dsn = NULL, ..., timezone = "UTC", timezone_out = "UTC", encoding = "", bigint = c("integer64", "integer", "numeric", "character"), timeout = 10, driver = NULL, server = NULL, database = NULL, uid = NULL, pwd = NULL, dbms.name = NULL, .connection_string = NULL )
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. |
timezone |
The Server time zone. Useful if the database has an internal
timezone that is not 'UTC'. If the database is in your local timezone set
to |
timezone_out |
The time zone returned to R. If you want to display
datetime values in the local timezone, set to |
encoding |
The text encoding used on the Database. If the database is
not using UTF-8 you will need to set the encoding to get accurate re-encoding.
See |
bigint |
The R type that |
timeout |
Time in seconds to timeout the connection attempt. Setting a
timeout of |
driver |
The ODBC driver name. |
server |
The server hostname. |
database |
The database on the server. |
uid |
The user identifier. |
pwd |
The password to use. |
dbms.name |
The database management system name. This should normally
be queried automatically by the ODBC driver. This name is used as the class
name for the OdbcConnect object returned from |
.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. |
The connection string keywords are driver dependent. 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.