Using the unixODBC driver manager

If you choose to use the unixODBC driver manager supplied by Sybase, you must verify that the driver selected is compatible with the unixODBC driver manager.

ECDA Option for ODBC version 15.0 ships with an open-source ODBC driver manager located in the <install_dir>/DC-15_0/drv_mgr/unixODBC-2.2.12 directory. To use the unixODBC driver manager, ECDA provides the folloiwng two options.

StepsTo use the unixODBC driver manager - Option 1

  1. In the dcany.cfg file, under the [Service Library] stanza, add this configuration value:

    ODBCDriverManager=<install_dir>/DC-15_0/drv_mgr /unixODBC-2.2.12/libodbc.yy.1.x.x 
    

    where:

    • yy represents the library extension so or sl.

    • x.x represents the numeric string appended to the library name.

StepsTo use the unixODBC driver manager - Option 2

  1. Move the library found in the <install_dir>/DC-15_0/drv_mgr /unixODBC-2.2.12 directory found in the ECDA runtime library path.In the dcany.cfg file, under the [Service Library] stanza, add this configuration value:

    ODBCDriverManager=libodbc.yy.1.x.x
    

    where:

    • yy represents the library extension so or sl.

    • x.x represents the numeric string appended to the library name.

    • <install_dir>/DC-15_0 must be expanded to the complete path name from the root directory. ECDA will not expand the variable.

    NoteThis driver manager uses the $ODBCSYSINI environment variable to locate the odbc.ini file.