Rogue Wave Component Builder (RCB): Building Your Applications : PART II Module-Specific Build Information : Chapter 4 DB Interface Module Build Information : Setting Environment Variables
Setting Environment Variables
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.
Table 5 – Environment 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.
Setting Environment Variables in Windows
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:
1. Enter the database variable name. Table 5 lists the possible database variable names.
2. Provide the path where your client is installed, in the following format:
 
drive:\<directory path>
3. 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.
Setting Environment Variables in UNIX
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