Verifying the ODBC Data Source for IBM DB2

This task is part of Verifying the ODBC Data Source.

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 CRM uses 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.

    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.