Administration Guide > Configuring TDV Data Connections > Using the ODBC Driver on UNIX > Setting the ODBC Environment Variables on UNIX
 
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.