Siebel Configuration

Verifying the ODBC Data Source for Oracle

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

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

  1. Navigate to Control Panel, Administrative Tools, then Data Sources (ODBC).
  2. On the ODBC Data Source Administrator dialog box, select the System DSN tab.
  3. Review the data source name; its default name is EnterpriseName_DSN, where EnterpriseName is the name you gave the Siebel Enterprise during its configuration.
  4. Record the name of the ODBC data source in Deployment Planning Worksheet if you have not already done so.
  5. Select the data source EnterpriseName_DSN, and click Configure.
    The ODBC Oracle Driver Setup screen appears.
  6. To test the connection, click Test Connect.
    If the connection is valid, you will see a message box confirming the connection.
  7. In the Windows registry, locate the following registry entry:

    [HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INIEnterpriseName_DSN]

    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


Source@Oracle Doc
@AskmeSiebel
Thanks for subscribing to SimplySiebel.

Leave a Reply

Your email address will not be published. Required fields are marked *