Bookshelf Home | Contents | Index | PDF     

Siebel Installation Guide for Microsoft Windows > Verifying and Troubleshooting Your Installation >

Verifying the ODBC Data Source

This topic provides information about verifying the ODBC data source for your enterprise database platform. It includes the following information:

Related Topics

Troubleshooting the ODBC Data Source Connection

Planning RDBMS Installation and Configuration

Verifying the ODBC Data Source for Oracle Database

Configuring the Siebel Enterprise automatically creates an ODBC system data source name (DSN) that the Siebel Server uses to connect to the Siebel database on the RDBMS.

Make sure that a supported version of the Oracle Database Client has been installed and that the Siebel Server service is started prior to verifying the ODBC data source. This topic applies also to virtual ODBC data sources in a clustered environment.

CAUTION:  In general, do not change the default settings that are created automatically with the ODBC data source. However, if you have upgraded from an Oracle Database that does not use CBO, or if you manually created your ODBC, then you must check your ODBC settings, as shown in the following procedure.

To verify the ODBC data source for Oracle Database (on Windows)

  1. Start the Microsoft ODBC Administrator.

    Run the 32-bit version of the Microsoft ODBC Administrator, which is located here: C:\Windows\SysWOW64\odbcad32.exe.

    NOTE:  You need the 32-bit version of the Microsoft ODBC Administrator because Siebel Business Applications use 32-bit ODBC drivers and database clients only.

  2. On the ODBC Data Source Administrator dialog box, select the System DSN tab.
  3. Review the data source name; its default name is SiebelEnterpriseName_DSN.

    In the data source name, SiebelEnterpriseName is the name that you gave the Siebel Enterprise during its configuration.

  4. Record the name of the ODBC data source in Siebel Deployment Planning Worksheet if you have not already done so.
  5. Select the data source SiebelEnterpriseName_DSN, and click Configure.

    The ODBC Oracle Driver Setup screen appears.

  6. To test the connection, click Test Connect.

    If the connection is valid, then you see a message box confirming the connection.

    If the connection could not be made, then see Verifying Network Connectivity for the Siebel Server Computer and Troubleshooting the ODBC Data Source Connection.

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

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

  8. 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

Verifying the ODBC Data Source for IBM DB2

Configuring the Siebel Enterprise automatically creates an ODBC system data source name (DSN) that the Siebel Server uses to connect to the Siebel database on the RDBMS.

Make sure that the appropriate database client has been installed and that the Siebel Server service is started prior to verifying the ODBC data source. This topic applies also to virtual ODBC data sources in a clustered environment.

CAUTION:  Do not change the default settings that are created automatically with the ODBC data source.

NOTE:  For information about verifying the ODBC data source for IBM DB2 for z/OS, see Implementing Siebel Business Applications on DB2 for z/OS.

To verify the ODBC data source for IBM DB2 (on Windows)

  1. Start the Microsoft ODBC Administrator.

    Run the 32-bit version of the Microsoft ODBC Administrator, which is located here: C:\Windows\SysWOW64\odbcad32.exe.

    NOTE:  You need the 32-bit version of the Microsoft ODBC Administrator because Siebel Business Applications use 32-bit ODBC drivers and database clients only.

  2. On the ODBC Data Source Administrator dialog box, select the System DSN tab.
  3. Review the data source name; its default name is EnterpriseName_DSN.

    In the data source name, EnterpriseName is the name that you gave the Siebel Enterprise during its configuration.

  4. Record the name of the ODBC data source in Siebel Deployment Planning Worksheet if you have not already done so.
  5. Select the data source EnterpriseName_DSN, and click Configure.

    A DB2 Message box appears to let you know your connection status.

    If you are not connected, then you are prompted whether you want to connect now to the data source.

  6. Click Yes.

    The Connect to DB2 Database screen appears.

  7. Type your user ID and passwords into the applicable fields, and click OK.

    If the connection is valid, then you see a message box confirming the connection.

    If the connection could not be made, then see Verifying Network Connectivity for the Siebel Server Computer and Troubleshooting the ODBC Data Source Connection.

  8. From the Windows command prompt, navigate to SIEBEL_ROOT\siebsrvr\BIN, and execute the following command:

    odbcsql /s ODBC_DSN /u database_account_name /p password

    where:

    • ODBC_DSN is the ODBC data source name, in the form SiebelEnterpriseName_DSN. In the data source name, SiebelEnterpriseName is the name of your Siebel Enterprise.
    • database_account_name is a valid database account name.
    • password is the corresponding database account password.

      When you connect, a confirmation message appears.

Verifying the ODBC Data Source for Microsoft SQL Server

Configuring the Siebel Enterprise automatically creates an ODBC system data source name (DSN) that the Siebel Server uses to connect to the Siebel database on the RDBMS.

Make sure that the appropriate database client has been installed and that the Siebel Server service is started prior to verifying the ODBC data source. This topic applies also to virtual ODBC data sources in a clustered environment.

CAUTION:  Do not change the default settings that are created automatically with the ODBC data source.

To verify the ODBC data source for Microsoft SQL Server

  1. Start the Microsoft ODBC Administrator.

    Run the 32-bit version of the Microsoft ODBC Administrator, which is located here: C:\Windows\SysWOW64\odbcad32.exe.

    NOTE:  You need the 32-bit version of the Microsoft ODBC Administrator because Siebel Business Applications use 32-bit ODBC drivers and database clients only.

  2. On the ODBC Data Source Administrator dialog box, select the System DSN tab.
  3. Review the data source name; its default name is SiebelEnterpriseName_DSN.

    In the data source name, SiebelEnterpriseName is the name that you gave the Siebel Enterprise during its configuration.

  4. Record the name of the ODBC data source in Siebel Deployment Planning Worksheet if you have not already done so.
  5. Select the data source SiebelEnterpriseName_DSN, and click Configure.

    The Microsoft SQL Server DSN Configuration screen appears.

  6. Click Next, and click Client Configuration.

    The Edit Network Library Configuration screen appears.

  7. Verify that the port number for the database is correct.
  8. If the port number is incorrect, then edit it, and then click OK.

    To edit the port number, you might have to first select and then deselect the check box Dynamically Determine Port.

    The Microsoft SQL Server DSN Configuration screen appears.

  9. Select verification with SQL Server using a valid database login ID and password that you enter in the Login ID and Password fields. Then click Next.

    The program tests the connection:

      
Siebel Installation Guide for Microsoft Windows Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices.