You must properly define all compiler-specific and database-specific environment variables and system settings before building the DB Interface Module libraries.
Table 5 lists an environment variable for each of the DB Interface Module access libraries and describes the typical settings required. The rest of this section provides operating system-specific instructions for setting the variables.
| Database | Variable Name | Notes |
| Microsoft SQL Server | n/a | For the SQL Server Native Client driver, RCB includes a field to specify the path to the driver installation directory. For the SQL Server driver, the compiler's default settings take care of this. |
| MySQL | n/a | RCB includes a field to specify the path to the MySQL installation. |
| DB2 CLI | DB2DIR | Set the variable to the path in which DB2 CLI is installed. |
| ODBC | ODBC | UNIX: Set the variable to the path in which the ODBC library and header files are installed. Microsoft: Do not set this variable. Your compiler's default settings take care of this for you. |
| Oracle OCI | ORACLE_HOME | Set the variable to the path in which Oracle is installed. |
| PostgreSQL | n/a | RCB includes a field to specify the path to the PostgreSQL installation. |
| Sybase | SYBASE | Set the variable to the path in which Sybase Open Client is installed. |
| SYBASE_OCS | See below. |
For Sybase, the bin and include directories that were located at the $SYBASE root level were moved into a directory with version 12 of the Sybase client. For the client version 15.5, you must set the SYBASE_OCS variable to OCS-15_0 to build the DB Access Module for Sybase.
For example, if the Sybase client is installed in the Windows directory C:\WINDOWS\SYBASE, you set the variable SYBASE to the value C:\WINDOWS\SYBASE. This directory also has a subdirectory C:\WINDOWS\SYBASE\OCS-15_0, so you set the variable SYBASE_OCS to the value OCS-15_0.
To set your environment variables in the Windows system registry:
Environment variables are generally set from Control Panel | System | Advanced |Environment Variables, depending on the version of your operating system.
Create a new variable (by clicking New), and:
Enter the database variable name. Table 5 lists the possible database variable names.
Provide the path where your client is installed, in the following format:
drive:\<directory path> |
Click Set and/or OK, depending on your system.
The variables that you set will not apply to any running programs, including RCB. Quit and restart RCB before compiling.
If you are working in a Korn or a Bourne shell, use export to set the environment variable. Table 5 lists the variable for your database. For example, to set the variable for the Oracle database, you might use something like the following:
export ORACLE_HOME=/oracle |
If you are running in other than a Bourne or Korn shell, you may be able to use setenv, as in the following:
setenv ORACLE_HOME /oracle |
Copyright © Rogue Wave Software, Inc. All Rights Reserved.
The Rogue Wave name and logo, and SourcePro, are registered trademarks of Rogue Wave Software. All other trademarks are the property of their respective owners.
Provide feedback to Rogue Wave about its documentation.