Adding Driver Descriptors to odbcinst.ini

For ODBC drivers that are installed with the EPM System, driver descriptors are automatically added to odbcinst.ini. For drivers that are not installed by the EPM System, you must manually add the driver descriptor to odbcinst.

  For MySQL, Netezza, and Teradata: To add the driver descriptor to odbcinst.ini:

  1. Locate the appropriate odbcinst.ini.

    32-bit:

    $EPM_ORACLE_HOME/common/ODBC/Merant/6.0/odbcinst.ini

    64-bit:

    $EPM_ORACLE_HOME/common/ODBC-64/Merant/6.0/odbcinst.ini

  2. Add the appropriate driver descriptor entry.

    For example:

    MySQL

    [ODBC Drivers]
MySQL ODBC 3.51 Driver =Installed

...

[MySQL ODBC 3.51 Driver]
Description = ODBC 3.51 for MySQL
DRIVER = /usr/lib/libmyodbc3.so
SETUP = /usr/lib/libmyodbc3S.so
UsageCount = 2

    Netezza

    [ODBC Drivers]
Netezza=Installed

[Netezza]
Driver=/usr/local/nz/lib/libnzodbc.so
Setup=/usr/local/nz/lib/libnzodbc.so

    Teradata

    [ODBC Drivers]
Teradata=Installed

[Teradata]
Driver=/usr/odbc/drivers/tdata.so
Setup=/usr/odbc/drivers/tdata.so

  3. Save the file and continue with Adding DSNs to the odbc.ini File.