Oracle
To complete the Oracle installation:
Note:
For Unix and Linux, the Oracle Client is installed as part of the CONNX installation. When installing CONNX on a Windows system, the Oracle Client must be downloaded from Oracle and installed separately.
1. Verify that the Data Source Name (DSN) CONNX32 is on the User DSN list of ODBC drivers. In Control Panel, double-click the 32bit ODBC icon. On the User DSN tab, verify that CONNX32 appears as both Name and Driver. If the CONNX32 DSN is not present, it has been erased. This DSN is essential to CONNX operation and must not be erased. To recover the erased CONNX32 DSN, repeat Installation on Windows.
2. Establish a connection with the Oracle test data using the test data and a utility program supplied with the CONNX installation. For more information on how to test the connection, see Testing a Database Connection.
3. To customize how CONNX is initialized, see CONNX Registry File Settings in the CONNX User Reference guide.
4. To properly configure the environment for Unix and Linux, define the following environment variables:
ORACLE_HOME=$CNXDIR/lib32 (Where CNXDIR is the CONNX Client installation path)
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
For Windows, download and install the Oracle Client from Oracle. Consult the Oracle documentation for information regarding specific values for your operating system.
5. For Unix and Linux, place a valid copy of tnsnames.ora into the directory defined by $ORACLE_HOME. Consult the Oracle documentation for information regarding the format of the tnsnames.ora configuration file. For Windows, consult the Oracle documentation for information regarding the location and format of the tnsnames.ora configuration file.
6. (Unix and Linux only) $CNXDIR/lib32 must be the first entry on the dynamic library search path. If necessary, add or move the $CNXDIR/lib32 path to the beginning of the LD_LIBRARY_PATH or equivalent environment variable search path.