<< Click to Display Table of Contents >> Navigation:  Configuration topics > Configuring Microsoft ODBC > Configuring the ODBC configuration file

Two files contain the configuration information for ODBC:

Use the administrative program ODBCADMIN to modify these files.To launch this program, choose Object|Vendor Configuration from any ODBC driver or alias.

The files are ASCII, but direct user editing is not recommended.

Here is a sample ODBC.INI file:

[ODBC Data Sources]

  My Oracle7=VENDOR Oracle7

 

  [My Oracle7]

  Driver=C:\windows\system\OR706.DLL

  Description=ODBC Oracle7 Driver

  ServerName=X:ZAPPA

  Servers=

  LogonID=guest

  LockTimeOut=

  ArraySize=

  QEWSD=34480

The first block [ODBC Data Sources] lists the ODBC data sources and their associated drivers. Then, for each data source, there is a block that describes the datasource. One data source [My Oracle7] is shown in the example above.  

Here is a sample ODBCINST.INI file (the file that describes the drivers):

[ODBC Drivers]

  VENDOR Oracle7=Installed

 

[VENDOR Oracle7]

  Driver=C:\ODBC\OR706.DLL

  Setup=C:\ODBC\OR706.DLL

  APILevel=1

  ConnectFunctions=YYY

  DriverODBCVer=02.01

  FileUsage=0

  SQLLevel=1

The first block [ODBC Drivers] lists the installed drivers. The second block is the configuration block for the first installed drivers.

Each datasource in the ODBC.INI file will have an installed driver (for example, VENDOR Oracle7) in the ODBCINST.INI file.