Siebel Database Upgrade Guide > Performing the Siebel Incremental Repository Merge > Process of Meeting the Requirements for an Incremental Upgrade of Siebel Innovation Pack 2013, Using the Incremental Repository Merge >

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


Use this task if you have a custom ODBC data source on Oracle Database.

This task is a step in Process of Meeting the Requirements for an Incremental Upgrade of Siebel Innovation Pack 2013, Using the Incremental Repository Merge.

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.

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>.
  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.
Siebel Database Upgrade Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.