1. Database Upgrade Guide
  2. Preparing Siebel Tools for Custom ODBC Data Source Names on Oracle Database

Preparing Siebel Tools for Custom ODBC Data Source Names on Oracle Database

Platforms: Windows.

This task applies if you have a custom ODBC data source on Oracle Database. If you create a custom ODBC data source name for Oracle Database instead of using the default ODBC data source name, then you must perform the following modifications to enable Siebel Tools for the incremental repository merge. After Siebel Tools is installed, the ODBC data source named SSD default instance is automatically set up by the configurations, using the Oracle driver installed by the installation.

This task is a step in Process of Meeting Requirements for an Incremental Repository Merge.

To prepare Siebel Tools for a custom data source name on Oracle Database

  1. Use the Siebel Tools default ODBC driver, Siebel Oracle90.

  2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC_DSN_name.

  3. Right-click the new custom ODBC name you created, and select New, then String Value, and enter the following names:

    • ColumnsAsChar

    • ColumnSizeAsCharacter

  4. After you create the values, select each value, right-click each one. For each value, choose Modify, then in the data field, enter the following values:

    • Set the ColumnsAsChar value to 1

    • Set the ColumnSizeAsCharacter value to 1

    Note: The ODBC SSD default instance automatically has these values in the registry, but you have to manually create them for the ODBC data source that you create.

  5. Click the System DSN tab of the ODBC connection that you intend to use, and then test the connection.