DSN-less connections
- Last Updated: March 4, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Database Wire Protocol 8.0
- Documentation
Connections to a data source can be made via a connection string without
referring to a data source name (DSN-less connections). This is done by specifying the
DRIVER= keyword instead of the DSN= keyword in a
connection string, as outlined in the ODBC specification. A file named odbcinst.ini must
exist when the driver encounters DRIVER= in a connection string.
Setup installs a default version of this file in the product installation directory (see "ODBCINST" for details about relocating and renaming this file). This is a plain text file that contains default DSN-less connection information. You should not normally need to edit this file. The content of this file is divided into several sections.
At the beginning of the file is a section named [ODBC
Drivers] that lists installed drivers, for example,
DataDirect 8.0 Oracle Wire Protocol=Installed
This section also includes additional information for each driver.
The final section of the file is named [ODBC]. The [ODBC] section in the
odbcinst.ini file fulfills the same purpose in
DSN-less connections as the [ODBC] section in the
odbc.ini file does for data source
connections. See "Connection option descriptions" for a description of the other
keywords this section.
[ODBC] section. If the information in these two sections is not the same,
the values in the odbc.ini
[ODBC] section override those of the odbcinst.ini
[ODBC] section.