You receive an error message when you use the Host Integration Server 2004 Data Access Tool (DAT) to perform a test connection or to run a sample query (915683)


The information in this article applies to:

  • Microsoft Host Integration Server 2004

SYMPTOMS

When you use the Data Access Tool (DAT) in Microsoft Host Integration Server 2004 to perform a test connection, you may receive the following error message:
Could not connect to data source 'New Data Source': The host resource could not be found. Check that the Initial Catalog value matches the host resource name. SQLSTATE: HY000, SQLCODE: -360
When you use the Data Source Wizard to create and to run a sample query, you may receive the following error message:
Could not connect to data source 'New Data Source': The 'DB2OLEDB' provider is not registered on the local machine.
Additionally, if you use an existing data source to run the sample query, you do not receive an error message. Instead, the sample query returns no data.

CAUSE

This behavior occurs if the Microsoft OLE DB Provider for DB2 (DB2OLEDB) that is included with Host Integration Server 2004 is not installed. The DAT uses this provider to perform test connections and to run sample queries.

RESOLUTION

To resolve this behavior, follow these steps:
  1. Click Start, click Control Panel, and then click Add or Remove Programs.
  2. Click Microsoft Host Integration Server 2004, click Change/Remove, and then click Modify.
  3. In the Custom Installation dialog box, expand Data Integration, click to select the OLE DB Provider for DB2 check box, and then click Next.
  4. Click Install.
  5. Click Finish.
  6. Close Add or Remove Programs.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to reproduce the behavior

  1. Install Host Integration Server 2004 on a client computer or on a server.
  2. Under Data Integration, click to clear the following check boxes:
    • ODBC Driver for DB2
    • OLE DB Provider for DB2
    Note Only the Managed Provider for DB2 check box should be selected.
  3. Follow the instructions to finish the installation process.
  4. Click Start, point to All Programs, point to Microsoft Host Integration Server 2004, and then click Data Access Tool.
  5. Try to create a UDL file. To do this, follow these steps:
    1. Right-click Data Sources, and then click New Data Source. The Data Source Wizard starts. Follow the instructions in the wizard.
    2. On the Data Source Wizard - Validation page, use one of the following procedures:
      • To perform a test connection, click Connect.
      • To run a sample query, click Sample Query.
      You receive an error message that is mentioned in the "Symptoms" section.
    .
Modification Type:MajorLast Reviewed:5/4/2006
Keywords:kbDB2OLEDB kbDataAccessTool kbExpertiseInter kbtshoot kbfix kbHIS2004 kbprb KB915683 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.