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 |
MS SQL Server | n/a | Your compiler's default settings take care of this for you. |
MySQL | n/a | RCB includes a field where the path to the MySQL installation may be entered. (This is not required on Windows.) |
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 where the path to the PostgreSQL installation may be entered. (This is not required on Windows.) |
Sybase CT Library | SYBASE | Set the variable to the path in which CT Library is installed. |
SYBASE_OCS | See below. |
For Sybase CT, 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 versions 12, 12.5, or 15.0, you must set the SYBASE_OCS variable to OCS-12_0, OCS-12_5, or OCS-15_0 respectively, to build the DB Access Module for Sybase CT.
For example, if the Sybase client is installed in the Windows directory C:\WINNT\SYBASE, you set the variable SYBASE to the value C:\WINNT\SYBASE. This directory also has a subdirectory C:\WINNT\SYBASE\OCS-12_5, so you set the variable SYBASE_OCS to the value OCS-12_5.
To set your environment variables in the Windows NT/2000 system registry:
Open the Control Panel window, and double click on the System icon.
On the environment variables screen:
Windows NT -- Click the Environment tab.
Windows 2000 -- Click the Advanced tab and then click the button labeled Environment Variables.
Click New.
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 or OK, and then click OK.
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 you must set for your database. For example, to set the variable for the Informix 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.
Rogue Wave and SourcePro are registered trademarks of Rogue Wave Software, Inc. in the United States and other countries. All other trademarks are the property of their respective owners.
Contact Rogue Wave about documentation or support issues.