Testing the ODBC driver installation and configuration

Use the # env | more command to perform a visual check on the following environment variables:

Environment variable	Description
ODBCINI	Must exist and must define the full-path filename of the odbc.ini file, just as you set it up in the configuration procedure described above. For example, if you used the default installation directory, you should see: ODBCINI=/opt/odbc/odbc.ini. The file odbc.ini (defined by ODBCINI) should also exist. To check for its existence, go to the directory specified in ODBCINI and make sure that odbc.ini exists in that directory. If it does not exist, you must create it.
HP-UX: SHLIB_PATHIBM AIX: LIBPATH Sun Solaris: LD_LIBRARY_PATH	Must contain the <DataDirect ODBC driver installation directory/lib> directory.

Environment variable

Description

ODBCINI

Must exist and must define the full-path filename of the odbc.ini file, just as you set it up in the configuration procedure described above. For example, if you used the default installation directory, you should see: ODBCINI=/opt/odbc/odbc.ini. The file odbc.ini (defined by ODBCINI) should also exist. To check for its existence, go to the directory specified in ODBCINI and make sure that odbc.ini exists in that directory. If it does not exist, you must create it.

HP-UX: SHLIB_PATHIBM

AIX: LIBPATH

Sun Solaris: LD_LIBRARY_PATH

Must contain the <DataDirect ODBC driver installation directory/lib> directory.

Use the # cat $ODBCINI | more command to perform a visual check on the odbc.ini file. Check the DSN definition to make sure that it points to the driver library for your ODBC database and that the ServerName points to your ODBC database.
Test the connection to the database in two ways. First, use the dBase driver and test data provided on the installation CD. If this is working correctly, create and use test data with the ODBC driver for your specific type of ODBC database. The tests will confirm that you can connect to the database and retrieve data from it.