4 Configuring the Product on UNIX/Linux : DSN-less Connections

DSN-less Connections
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 Oracle Wire Protocol=Installed.
This section also includes additional information for each driver.
The next section of the file is named [Administrator]. The keyword in this section, AdminHelpRootDirectory, is required for the Linux ODBC Administrator to locate its help system. The installation process automatically provides the correct value for this keyword.
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 “Configuration Through the System Information (odbc.ini) File” for a description of the other keywords this section.
NOTE: The odbcinst.ini file and the odbc.ini file include an [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.
Sample odbcinst.ini File
The following is a sample odbcinst.ini. All occurrences of ODBCHOME are replaced with your installation directory path during installation of the file. Commented lines are denoted by the # symbol. This sample shows 32-bit drivers with file names beginning with iv; a 64-bit driver file would be identical except that driver names would begin with dd.
[ODBC Drivers]
DataDirect 7.0 DB2 Wire Protocol=Installed
DataDirect 7.0 dBASEFile (*.dbf)=Installed
DataDirect 7.0 Greenplum Wire Protocol=Installed
DataDirect 7.0 Informix Wire Protocol=Installed
DataDirect 7.0 MySQL Wire Protocol=Installed
DataDirect 7.0 Oracle Wire Protocol=Installed
DataDirect 7.0 PostgreSQL Wire Protocol=Installed
DataDirect 7.0 Progress OpenEdge Wire Protocol=Installed
DataDirect 7.0 SQL Server Wire Protocol=Installed
DataDirect 7.0 Sybase Wire Protocol=Installed
DataDirect 7.0 Salesforce=Installed
DataDirect 7.0 Teradata=Installed
DataDirect 7.0 TextFile (*.*)=Installed
DataDirect 7.0 Informix=Installed
DataDirect 7.0 Oracle=Installed
DataDirect 7.0 SQL Server Legacy Wire Protocol=Installed
 
[DataDirect 7.0 DB2 Wire Protocol]
Driver=ODBCHOME/lib/ivdb226.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
Setup=ODBCHOME/lib/ivdb226.so
SQLLevel=0
 
[DataDirect 7.0 dBASEFile (*.dbf)]
Driver=ODBCHOME/lib/ivdbf26.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileExtns=*.dbf
FileUsage=1
HelpRootDirectory=ODBCHOME/help
Setup=ODBCHOME/lib/ivdbf26.so
SQLLevel=0
 
[DataDirect 7.0 Greenplum Wire Protocol]
Driver=ODBCHOME/lib/ivgplm26.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
Setup=ODBCHOME/lib/ivgplm26.so
SQLLevel=0
 
[DataDirect 7.0 Informix Wire Protocol]
Driver=ODBCHOME/lib/ivifcl26.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
Setup=ODBCHOME/lib/ivifcl26.so
SQLLevel=0
 
[DataDirect 7.0 MySQL Wire Protocol]
Driver=ODBCHOME/lib/ivmysql26.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
Setup=ODBCHOME/lib/ivmysql26.so
SQLLevel=0
 
[DataDirect 7.0 Oracle Wire Protocol]
Driver=ODBCHOME/lib/ivora26.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
Setup=ODBCHOME/lib/ivora26.so
SQLLevel=0
 
[DataDirect 7.0 PostgreSQL Wire Protocol]
Driver=ODBCHOME/lib/ivpsql26.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
Setup=ODBCHOME/lib/ivpsql26.so
SQLLevel=0
 
[DataDirect 7.0 Progress OpenEdge Wire Protocol]
Driver=ODBCHOME/lib/ivoe26.so
APILevel=1
ConnectFunctions=YYN
DriverODBCVer=3.52
SQLLevel=0
 
[DataDirect 7.0 SQL Server Wire Protocol]
Driver=ODBCHOME/lib/ivsqls26.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
SQLLevel=0
 
[DataDirect 7.0 Sybase Wire Protocol]
Driver=ODBCHOME/lib/ivase26.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
Setup=ODBCHOME/lib/ivase26.so
SQLLevel=0
 
[DataDirect 7.0 Salesforce]
Driver=ODBCHOME/lib/ivsfrc26.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
SQLLevel=0
 
[DataDirect 7.0 Sybase IQ Wire Protocol]
Driver=ODBCHOME/lib/ivsyiq26.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
SQLLevel=0
 
[DataDirect 7.0 Teradata]
Driver=ODBCHOME/lib/ivtera26.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
Setup=ODBCHOME/lib/ivtera26s.so
SQLLevel=0
 
[DataDirect 7.0 TextFile (*.*)]
Driver=ODBCHOME/lib/ivtxt26.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileExtns=*.*
FileUsage=1
HelpRootDirectory=ODBCHOME/help
Setup=ODBCHOME/lib/ivtxt26.so
SQLLevel=0
 
[DataDirect 7.0 Informix]
Driver=ODBCHOME/lib/ivinf26.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
SQLLevel=0
 
[DataDirect 7.0 Oracle]
Driver=ODBCHOME/lib/ivor826.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
Setup=ODBCHOME/lib/ivor826s.so
SQLLevel=0
 
[DataDirect 7.0 SQL Server Legacy Wire Protocol]
Driver=ODBCHOME/lib/ivmsss26.so
APILevel=2
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=ODBCHOME/help
Setup=ODBCHOME/lib/ivmsss26s.so
SQLLevel=0
 
[Administrator]
HelpRootDirectory=ODBCHOME/adminhelp
 
[ODBC]
#This section must contain values for DSN-less connections
#if no odbc.ini file exists. If an odbc.ini file exists,
#the values from that [ODBC] section are used.
 
IANAAppCodePage=4
InstallDir=ODBCHOME
Trace=0
TraceFile=odbctrace.out
TraceDll=ODBCHOME/lib/odbctrac.so
ODBCTraceMaxFileSize=102400
ODBCTraceMaxNumFiles=10