Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Installing the Siebel Server >

Verifying the ODBC Data Source for Oracle

The Siebel Server installation program automatically creates an ODBC system data source name (DSN) that it uses to connect to the Siebel Database Server. Prior to verifying the Siebel Server ODBC data source, make sure that the Siebel Server service is started.

CAUTION:  In general, do not change the default settings created automatically with the ODBC data source. However, if you have upgraded from Oracle 8i to Oracle 9i, or if you have manually created your ODBC, it is critical that you check your ODBC settings, as shown in the following procedure.

To verify the ODBC data source for Oracle

1. Navigate to $SIEBEL_HOME/sys/.odbc.ini.
2. Locate the section of the file containing a reference to ServerName and Driver.

   This section defines the ODBC DSN for Siebel Server. A sample section is represented in the following example. The ServerName, Driver, ColumnsAsChar, and ColumnSizeAsCharacter parameters are the most critical for this procedure:

   [SiebSrvr_Enterprise Name]
   Description=Oracle901
   ServerName=dvlsun6
   Driver=$SIEBEL_HOME/lib/SEor818.so
   ColumnsAsChar=1
   ColumnSizeAsCharacter=1

   CAUTION:  The ColumnsAsChar and ColumnSizeAsCharacter parameter settings are required for Oracle 9i, in order for the ODBC driver to behave correctly.

   The ServerName should be the Oracle connect string you entered while installing the Siebel Server. (To verify this connect string, run sqlplus.) The driver should point to $SIEBEL_HOME/lib/SEor818.so, allowing you to verify the existence of this file.

3. Verify that the SIEBEL_UNIXUNICODE_DB environment variable is set to ORACLE.

   NOTE:  If you are using Siebel Marketing, which requires simultaneous heterogeneous database connectivity, you need to set this variable to ORACLE, regardless of your database platform.

4. Test the connection by navigating to $SIEBEL_HOME/bin and entering the command:

   odbcsql /u user_name /p password /s ODBC DSN

   where:

   ODBC DSN = the database connect string

   If you do not receive an error message, the ODBC connection is working.

   If your ODBC DSN is not working, the program exits with an error message. For more information, see Troubleshooting the ODBC Data Source Connection.