Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Installing Siebel Tools > Postinstallation Tasks for Siebel Tools >

Verify Siebel Tools ODBC Data Sources


The Siebel Tools Installer creates the ODBC data sources described in Table 15. By default, these are created as system data sources, which are visible to all user accounts on the machine where Siebel Tools is installed.

CAUTION:  Because the total length of the data source name must be no more than 32 characters, make sure you select a short name for your local database. If you select a long name for your local database (for example, SSD LOCAL DB M:/SIEBEL/10910/TOOLS), the data source created by the Siebel Tools Installer will not appear under the System DNS tab and you will experience failure of Siebel Tools operations such as checkout.

Table 15.  Siebel Tools ODBC Data Sources
Data Source
Use

SSD Local Db default instance

Connects to the local SQL Anywhere database.

SSD

Connects to the DB2 database.

SSD default instance

Connects to the Microsoft SQL Server or Oracle database.

For Oracle 8i or 9i, 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

If you have upgraded your database from Oracle 8i to Oracle 9i, verify that the following registry keys are set as shown. These values are required in order for the ODBC driver to behave correctly.

ColumnsAsChar = 1
ColumnSizeAsCharacter = 1

Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools