Setting the ODBC Environment Variables on UNIX

For examples and instructions for how to set UNIX environment variables, refer to your favorite UNIX guidelines. A typical command might be:

setenv PATH "/bin:/usr/bin:/usr/sbin:ucb/bin"

To set the ODBC environment variables

1. Log into the installation machine as the same user that installed the TDV software.
2. Set the following environment variables:

Variable

Description and Values

COMPOSITE_HOME

This optional variable allows you to specify the location where the TDV ODBC driver is installed. This is the full path to the <TDV_ODBC_install_dir> for the TDV ODBC driver.

If this configuration is not set, you can run driverConfig with an absolute or relative path, for example:

./home/release/apps/odbc/linux64/bin/driverConfig
./odbc/linux64/bin/driverConfig
./bin/driverConfig

If this variable is set to /home/release, then when you create a DSN, it goes to /home/release/apps/odbc/linux64/lib to find the so files.

ODBCINI

Full path to the configuration file odbc.ini. It is generated during creation of DSN configuration with driverConfig. The ODBCINI and ODBCINSTINI files do not exist yet and will be created during DSN creation in the next step. It should be: <TDV_install_dir>/odbc.ini

ODBCINSTINI

Full path to the ODBC drivers configuration file odbcinst.ini. It is generated during DSN configuration with driverConfig. The ODBCINI and ODBCINSTINI files do not exist yet and will be created during DSN creation in the next step. It should be: <TDV_install_dir>/odbcinst.ini

LD_LIBRARY_PATH

This is specific to Linux. This path refers to the location of the iODBC driver manager files. The default location is:

<TDV_install_dir>\apps\odbc\<platformType>\lib

If you already have this variable, add the additional path to the existing path definition.

LIBPATH

This is specific to AIX. This path refers to the location of the iODBC driver manager files. The default location is:

<TDV_install_dir>\apps\odbc\<platformType>\lib

SHLIB_PATH

This is specific to HP-UX. This path refers to the location of the iODBC driver manager files. The default location is:

<TDV_install_dir>\apps\odbc\<platformType>\lib

3. Add these variables to the users profile that will be accessing the ODBC driver.