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

Verifying the ODBC Data Source for DB2 UDB


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:  Do not change the default settings created automatically with the ODBC data source.

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

To verify the ODBC data source for DB2 UDB for UNIX and Windows (on Windows)

  1. Navigate to Start > Programs > Administrative Tools > Data Sources (ODBC).
  2. On the ODBC Data Source Administrator dialog box, select System DSN.
  3. Review this data source (whose default name is SiebSrvr_EnterpriseName) and record the name in Deployment Planning Worksheet if you have not already done so. You will need this information when you are installing the Siebel Database Server.
  4. On the ODBC Data Source Administrator screen, select the data source and click Configure.

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

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

  5. Click Yes.

    The Connect to DB2 Database screen appears.

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

    A message box appears, announcing:

    Connect Completed Successfully

    If you still cannot connect, verify that your database is running and that you used the correct login information.

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

    odbcsql /s data_source /u database_account_name/p password

    where:

    • data_source = The name of the data source
    • database_account_name = A valid database account name
    • password = The corresponding database account password

      When you connect, a confirmation message should appear.

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