Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Installing the Siebel Server >

Verifying the ODBC Data Source for Oracle

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.

CAUTION:  In general, do not change the default settings created automatically with the ODBC data source. However, if you have upgraded from Oracle 8i to either Oracle 9i or 10g, or if you manually created your ODBC, it is critical that you check your ODBC settings, as shown in the following procedure.

For more information about the ODBC data source, see Planning RDBMS Installation and Configuration.

To verify the ODBC data source for Oracle on Windows

1. Navigate to Start > Programs > Administrative Tools > Data Sources (ODBC).
2. On the ODBC Data Source Administrator screen, select the System DSN tab.
3. Review this data source; its default name is SiebSrvr_EnterpriseName, 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.

   You will need this information when you are installing the Siebel Database Server.

5. Select the data source SiebSrvr_EnterpriseName, 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.

   If the connection could not be made, see Troubleshooting the ODBC Data Source Connection.

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

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

   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