Survox ODBC Interface setup information

Below is general information on what is needed to setup the Survox ODBC interface:

Survox Support policy:

Installation of the ODBC-compliant database as well as the ODBC API (application programming interface) will be the responsibility of the client. All knowledge of the ODBC-compliant database is the responsibility of the client.

ODBC-compliant databasesinstalled on Survox Machines are:

MySQL

Microsoft Access (using EasySoft)

Other known ODBC-complianthttp://www.unixodbc.com/drivers.html) are:

AdabasD

Empress

IBM DB2

Informix

Interbase

Microsoft SQL

Mimer SQL

MiniSQL

News Server

Ovrimos Webbase

Postgres

RDBMS Linter SQL

SQL

Starquest DB2

Sybase

Yard SQL

ODBC API:

The ODBC API (application programming interface) serves as a bridge between CfMC software and the ODBC-compliant software. It must be installed in order for the different software to communicate with each other.

For more details,http://www.unixodbc.com/

Additional environment variable:

LD_LIBRARY_PATH points to the location of the ODBC API

Add to .login:

setenv LD_LIBRARY_PATH

This example is for EasySoft:

setenv LD_LIBRARY_PATH /usr/local/easysoft/lib:/usr/local/easysoft/oob/client:/usr/local/easysoft/unixODBC/lib

Troubleshooting:

Error:dynamic linker: mentor: error opening libodbc.so.1

Explanation:The ODBC API cannot be found (in example, libodbc.so.1 is the ODBC API)

Solution:As root, type “find / -name libodbc.so.1 -print”, add directory where the ODBC API is located to LD_LIBRARY_PATH environment variable for user.