There are required and optional environment variables for Microsoft SQL
Server data sources. These variables are set in the db2dj.ini file.
The following environment variables are valid for Microsoft SQL
Server:
- DJX_ODBC_LIBRARY_PATH
- ODBCINI
- LD_LIBRARY_PATH (Solaris only)
Variable descriptions
- DJX_ODBC_LIBRARY_PATH
- Specifies the directory path to the ODBC library files. This variable
must also be specified on federated servers that run Solaris.
For example:
DJX_ODBC_LIBRARY_PATH=ODBC_driver_directory/lib
ODBC_driver_directory is the directory
path where the ODBC driver is installed.
- ODBCINI
- Specifies the directory path where your ODBC configuration file (odbc.ini)
is located.
For example:
ODBCINI=/home/db2inst1/.odbc.ini
Do not set the ODBCINI environment variable as a system
variable.
- LD_LIBRARY_PATH (Solaris only)
- On federated servers that run Solaris, specifies the directory path to
the ODBC library files.
For example:
LD_LIBRARY_PATH=ODBC_driver_directory/lib