Microsoft KB Archive/915683

= 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 =

Article ID: 915683

Article Last Modified on 12/4/2007

-

APPLIES TO


 * Microsoft Host Integration Server 2004 Standard Edition

-





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.



Steps to reproduce the behavior
 Install Host Integration Server 2004 on a client computer or on a server. 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.</li> Follow the instructions to finish the installation process.</li> Click Start, point to All Programs, point to Microsoft Host Integration Server 2004, and then click Data Access Tool.</li> Try to create a UDL file. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Right-click Data Sources, and then click New Data Source. The Data Source Wizard starts. Follow the instructions in the wizard.</li> On the Data Source Wizard - Validation page, use one of the following procedures:  To perform a test connection, click Connect.</li> To run a sample query, click Sample Query.</li></ul>

You receive an error message that is mentioned in the &quot;Symptoms&quot; section.</li></ol>

.</li></ol>

Keywords: kbtshoot kbfix kbprb kbexpertiseinter kbhis2004 kbdataaccesstool kbdb2oledb KB915683

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.