1. Installation Guide
  2. Verifying the ODBC Data Source for Oracle Database

Verifying the ODBC Data Source for Oracle Database

This task is part of Verifying the ODBC Data Source.

Configuring the Siebel Enterprise automatically creates an ODBC system data source name (DSN) that the Siebel Server uses to connect to the Siebel database on the RDBMS.

Make sure that a supported version of the Oracle Database Client has been installed and that the Siebel Server service is started prior to verifying the ODBC data source. This topic applies also to virtual ODBC data sources in a clustered environment.

Caution: In general, do not change the default settings that are created automatically with the ODBC data source. However, if you have upgraded from an Oracle Database that does not use CBO, or if you manually created your ODBC, then you must check your ODBC settings, as shown in the following procedure.

To verify the ODBC data source for Oracle Database (on Windows)

  1. Start the Microsoft ODBC Administrator.

    Run the 32-bit version of the Microsoft ODBC Administrator, which is located here: C:\Windows\SysWOW64\odbcad32.exe.

    Note: You need the 32-bit version of the Microsoft ODBC Administrator because Siebel CRM uses 32-bit ODBC drivers and database clients only.

  2. On the ODBC Data Source Administrator dialog box, select the System DSN tab.

  3. Review the data source name; its default name is SiebelEnterpriseName_DSN.

    In the data source name, SiebelEnterpriseName is the name that you gave the Siebel Enterprise during its configuration.

  4. Record the name of the ODBC data source in Siebel Deployment Planning Worksheet if you have not already done so.

  5. Select the data source SiebelEnterpriseName_DSN, and click Configure.

    The ODBC Oracle Driver Setup screen appears.

  6. To test the connection, click Test Connect.

    If the connection is valid, then you see a message box confirming the connection.

    If the connection could not be made, then see Verifying Network Connectivity for the Siebel Server Computer and Troubleshooting the ODBC Data Source Connection.

  7. In the Windows registry, locate the following registry entry:

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SiebelEnterpriseName_DSN]

  8. Verify that the following registry keys are set as shown. These values are required in order for the ODBC driver to behave correctly.

    PacketSize = 0
EnableScrollableCursors = 0
ColumnsAsChar = 1
ColumnSizeAsCharacter = 1