Installed ODBC drivers use the odbcinst.ini sample file, which is located in $INFORMIXDIR/etc/odbcinst.ini. To create your odbcinst.ini file, copy the odbcinst.ini sample file to your home directory as $HOME/.odbcinst.ini (note the added dot at the beginning of the filename). This file has entries for all the installed drivers on your computer. Update this file when you install a new driver or a new version of a driver. The following table describes section items in the $HOME/.odbcinst.ini file.
| Section | Description | Status |
|---|---|---|
| ODBC Drivers | List of names of all the installed ODBC drivers | Optional |
| ODBC Driver Specifications | List of driver attributes and values | Optional |
This section provides information on ODBC drivers.
The following example illustrates information about drivers:
[ODBC Drivers] driver_name1=Installed driver_name2=Installed
·
·
·
The following example illustrates information about installed drivers:
[ODBC Drivers] INFORMIX 2.8 32 BIT=Installed INFORMIX 3.81 32 BIT=Installed
Each installed driver has a properties section under the name of the driver. The following example illustrates a driver-specification format:
[driver name1] Driver=driver_library_path Setup=setup/driver_library_path APILevel=api_level_supported ConnectFunctions=connectfunctions DriverODBCVer=odbc_version FileUsage=file_usage SQLLevel=sql_level
·
·
·
The following example illustrates information about driver specifications:
[INFORMIX 3.81 32] Driver=/vobs/tristarm/odbc/iclis09b.so Setup=/vobs/tristarm/odbc/iclis09b.so APILevel=1 ConnectFunctions=YYY DriverODBCVer=03.81 FileUsage=0 SQLLevel=1
The following table describes the keywords that are in the driver- specification section.
| Keywords | Description | Status |
|---|---|---|
| API Level | ODBC interface conformance level that the driver supports
|
Required |
| ConnectFunctions | Three-character string that indicates whether the driver supports SQLConnect, SQLDriverConnect, and SQLBrowseConnect | Required |
| DriverODBCVer | Character string with the version of ODBC that the driver supports | Required |
| Driver | Driver library path | Required |
| FileUsage | Number that indicates how a file-based driver directly treats files in a DSN | Required |
| Setup | Setup library | Required |
| SQLLevel | Number that indicates the SQL-92 grammar that the driver supports | Required |
For a detailed description of the Driver Specification section, see the IBM Informix: Microsoft ODBC 3.0 Programmer's Reference.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]