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

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:When you use the Data Source Wizard to create and to run a sample query, you may receive the following error message: 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.

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.

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.

This behavior is by design.

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: a. Right-click Data Sources, and then click New Data Source. The Data Source Wizard starts. Follow the instructions in the wizard. b. 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. .