Microsoft KB Archive/934195

= BUG: A .udl file may not work correctly in the Data Access Tool (DAT) that is included in Host Integration Server 2006 =

Article ID: 934195

Article Last Modified on 3/26/2007

-

APPLIES TO


 * Microsoft Host Integration Server 2006

-



SYMPTOMS
Consider the following scenario. You create a universal data link (.udl) file by using a tool other than the Data Access Tool (DAT) that is included in Microsoft Host Integration Server 2006. For example, you create a .udl file by using Notepad, a Microsoft BizTalk Server data adapter, or some other tool. In this scenario, the .udl file may not work correctly in the DAT.



CAUSE
By default, the DAT makes some specific assumptions about the transport properties. The DAT creates a .udl file that is based on those assumptions. Other tools may not make the same assumptions. Additionally, the connection mechanism of the other tools may work differently from the connection mechanism of the DAT. Therefore, the .udl file that you create by using the other tools may not work correctly in the DAT.



RESOLUTION
When you create a .udl file by using a tool other than the DAT, make sure that you specify the transport properties in the .udl file completely. Therefore, the DAT does not make any assumptions about the transport properties.

If a connection test for the .udl file is unsuccessful in the DAT, open the .udl file in the DAT. Then, specify the transport properties.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.



Steps to reproduce the problem

 * 1) Create a .udl file by using a tool other than the DAT. For example, save a .udl file when you create a linked server in Microsoft SQL Server.
 * 2) Start the DAT.
 * 3) Drag the .udl file to the DAT window.
 * 4) On the Actions menu, click Test Connection.

Keywords: kbtshoot kbbug KB934195

-

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

© Microsoft Corporation. All rights reserved.