Siebel Database Upgrade Guide > Preparing an Oracle Database for a Siebel Upgrade >

Verifying the Oracle Database ODBC Definition for a Siebel Upgrade

Environments: Development, production test, production.

Databases: Oracle only.

When you install a Siebel Server, the installer creates the ODBC definition for the Oracle Database you specify.

When you upgrade your production test environment and your production environment, you must manually create an ODBC definition for connecting to your development environment database.

Verifying or Editing an ODBC Definition on Windows

Use the following procedure to verify or edit an ODBC definition on Windows.

To verify or edit an ODBC definition on Windows

1. Start the registry editor (regedit).

   CAUTION:  Editing the registry can adversely affect the operating system. Be sure you understand how to use regedit correctly.

2. Navigate to the following location:

   HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ODBC_Name

   In this entry, ODBC_Name is the ODBC name for the Oracle Database.

3. In the data display pane, verify that the following entries are present:

If these entries are not present, then right-click in the data display pane, and choose New, and then String Value to add them.

4. Step off the ODBC_Name and return to it. Verify that the two new entries are present and correct.
5. Close the Registry Editor and reboot.

Verifying or Editing an ODBC Definition on UNIX

Use the following procedure to verify or edit an ODBC definition on UNIX.

To verify or edit an ODBC definition on UNIX

1. Navigate to the following file in the Siebel Server installation directory:

   $SIEBEL_ROOT/sys/.odbc.ini

2. Open the .odbc.ini file and add the following two entries:

   Set the ColumnsAsChar value to 1.

   Set the ColumnSizeAsCharacter to 1.

3. Save the file.
4. Stop and restart any processes that are using this .odbc.ini file.