Siebel Server Installation Guide for Microsoft Windows > Installing the Siebel Server > Post-Installation Tasks for the Siebel Server >

Verifying the Siebel Server ODBC Data Source

The Siebel Server installation program automatically creates an ODBC system data source name (DSN) that it uses to connect to the Siebel Database Server. Prior to verifying the Siebel Server ODBC data source, make sure that the Siebel Server service is started.

To verify the ODBC data source for DB2 UDB for Windows 2000 and UNIX

  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 Worksheets. if you have not already done so.

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

    NOTE:  Siebel Systems does not recommend changing the default settings created automatically with the ODBC data source.

  4. On the ODBC Data Source Administrator dialog box, select the data source and click Configure.

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

    6. The Connect To DB2 Database dialog box appears.

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

    7. A message box should appear, announcing:

    Connect Completed Successfully

    NOTE:  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:

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

To verify the ODBC data source for DB2 under Windows NT

  1. Navigate to Start >Settings >Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN.
  2. Review this data source (whose default name is SiebSrvr_EnterpriseName) and record the name in Deployment Planning Worksheets if you have not already done so.

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

    NOTE:  Siebel Systems does not recommend changing the default settings created automatically with the ODBC data source.

  3. On the ODBC Data Source Administrator dialog box, select the data source and click Configure.

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

  4. Click Yes.

    5. The Connect To DB2 Database dialog box appears.

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

    6. A message box appears, announcing:

    Connect Completed Successfully

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

To verify the ODBC data source for Oracle under Windows 2000

  1. Navigate to Start >Programs >Administrative Tools >Data Sources (ODBC).
  2. On the ODBC Data Source Administrator dialog box, select the System DSN tab.
  3. Review this data source; its default name is SiebSrvr_EnterpriseName.
  4. Record the name of the ODBC data source in Deployment Planning Worksheets if you have not already done so.

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

    NOTE:  Siebel Systems does not recommend changing the default settings created automatically with the ODBC data source.

  5. Select the data source SiebSrvr_EnterpriseName, which is the name you gave the Enterprise during its configuration, and click the Configure button.

    6. The ODBC Oracle Driver Setup dialog box appears.

  6. To test the connection, click the Test Connect button:

    7. If the connection is valid, you will see a message box to that effect.

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

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

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

    Verify that the following two options are set to 1:

    ColumnsAsChar = 1

    ColumnSizeAsCharacter = 1

    NOTE:  These two options are critical to guarantee correct ODBC driver behavior.

To verify the ODBC data source for Oracle under Windows NT

  1. Navigate to Start >Settings >Control Panel, choose
    Data Sources (ODBC) > System DSN.
  2. Review this data source; its default name is SiebSrvr_EnterpriseName.
  3. Record the name of the ODBC data source in Deployment Planning Worksheets if you have not already done so.

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

    NOTE:  Siebel Systems does not recommend changing the default settings created automatically with the ODBC data source.

  4. Select the data source SiebSrvr_EnterpriseName, which is the name you gave the Enterprise during its configuration, and click the Configure button.

    5. The ODBC Oracle Driver Setup dialog box appears.

  5. To test the connection, click the Test Connect button:

To verify the ODBC data source for MS SQL Server under Windows 2000

  1. Navigate to Start >Programs >Administrative Tools >Data Sources (ODBC).
  2. On the ODBC Data Source Administrator dialog box, select System DSN.
  3. Record the name of the ODBC data source in Deployment Planning Worksheets. if you have not already done so.

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

    NOTE:  Siebel Systems does not recommend changing the default settings created automatically with the ODBC data source.

  4. Select the data source SiebSrvr_EnterpriseName, which is the name you gave the Enterprise during its configuration, and click the Configure button.

    5. The Microsoft SQL Server DSN Configuration dialog box appears.

  5. Click Client Configuration.

    6. The Add Network Library Configuration dialog box appears.

  6. Verify that the port number for the database is correct. If it is not, edit it.

    7. To continue, click OK.

    The Microsoft SQL Server DSN Configuration dialog box appears again.

  7. Click Next.

    8. A second MS SQL Server DSN Configuration dialog box appears.

  8. Select verification with SQL Server using a login ID and password, and enter these in the Login ID and Password fields.

    9. The program tests the connection:

To verify the ODBC data source for MS SQL Server under Windows NT

  1. Navigate to Start >Settings >Control Panel, choose
    Data Sources (ODBC) >System DSN. Review this data source; its default name is SiebSrvr_EnterpriseName.
  2. Record the name of the ODBC data source in Deployment Planning Worksheets if you have not already done so.

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

    NOTE:  Siebel Systems does not recommend changing the default settings created automatically with the ODBC data source.

  3. Select the data source SiebSrvr_EnterpriseName, which is the name you gave the Enterprise during its configuration, and click the Configure button.

    4. The Microsoft SQL Server DSN Configuration dialog box appears.

  4. Click Client Configuration.

    5. The Add Network Library Configuration dialog box appears.

  5. Verify that the port number for the database is correct. If it is not, edit it.

    6. To continue, click OK.

    The Microsoft SQL Server DSN Configuration dialog box appears again.

  6. Click Next.

    7. A second MS SQL Server DSN Configuration dialog box appears.

  7. Select verification with SQL Server using a login ID and password, and enter these in the Login ID and Password fields.

    8. The program tests the connection:

Troubleshooting ODBC Data Source Connection

If your connection test for the ODBC data source fails, follow the instructions below to research the cause.

DB2 UDB for Windows and UNIX

To troubleshoot connection problems on Windows 2000 and Windows NT, see Verifying Network Connectivity and verify that your database is running. The installer verifies that the correct driver exists on the machine at installation time.

Oracle

Follow the instructions below to troubleshoot connection problems on Windows 2000 and Windows NT.

To troubleshoot a failed ODBC connection

  1. Verify that the ODBC driver was correctly installed by reviewing the file structure under SIEBEL_ROOT\BIN.
  2. If the files have been correctly copied to the \BIN subdirectory, verify that the Oracle connect string that you entered during Siebel Server configuration was valid.
MS SQL Server

Follow the instructions below to troubleshoot connection problems on Windows 2000 and Windows NT.

To troubleshoot a failed ODBC connection

  1. Verify that the ODBC driver was correctly installed by reviewing the file structure under SIEBEL_ROOT\BIN.
  2. If the files have been correctly copied to the \BIN subdirectory, verify that the data source name (SiebSrvr_EnterpriseName) that you entered during Siebel Server configuration was valid.

 Siebel Server Installation Guide for Microsoft Windows 
 Published: 25 June 2003