Function | Description |
---|---|
SQLConnect Function | SQLConnect supports both ApplicationIntent and MultiSubnetFailover via a data source name (DSN) or connection attribute. |
SQLDriverConnect Function | SQLDriverConnect supports ApplicationIntent and MultiSubnetFailover via DSN, connection string keyword, or connection attribute. |
odbc::odbcListDrivers()
.odbcinst
, which can be used toquery and modify the DSN files. However, these are plain text files youcan also edit by hand if desired.odbcinst.ini
defines driver optionsodbc.ini
defines connection optionsodbcinst.ini
./etc/odbc.ini
or /opt/local/etc/odbc.ini
. The file location depends onwhat option was used when compiling unixODBC; odbcinst -j
can be used to findthe exact location. Alternatively, the ODBCSYSINI
environment variable can beused to specify the location of the configuration files. Ex. ODBCSYSINI=~/ODBC
~/.odbc.ini
and ~/.odbcinst.ini
.dbConnect()
function.