Microsoft KB Archive/904799

= The &quot;Data Source&quot; field is a text box, the Refresh button does not appear, and you cannot attach a database file as a database name when you try to create a Microsoft Data Link file by using the SQL Native Client provider in SQL Server 2005 =

Article ID: 904799

Article Last Modified on 3/11/2006

-

APPLIES TO


 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Express Edition
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Workgroup Edition

-



Bug #: 391217 (SQL Server 8.0)

Bug #: 389946 (SQL Server 8.0)



SYMPTOMS
Consider the following scenario. You try to create a Microsoft Data Link (.udl) file by using the SQL Native Client (SQLNCLI) provider together with the Data Links wizard. You may notice the following symptoms:
 * The Data Source field on the Connection tab is a text box instead of a drop-down list, as expected.
 * The Refresh button does not appear next to the Data Source field.
 * On the Connection tab, no option exists to attach a database file as a database name. This option exists when you use the Microsoft OLE DB Provider for SQL Server (SQLOLEDB).



WORKAROUND
To work around this problem, use the following methods:
 * To specify the data source, directly input the server name in the Data Source field.
 * To attach a database, click the All tab on the Data Link Properties dialog box. Then, set the Initial File Name property to the database file name.



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

Keywords: kbtshoot KB904799

-

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

© Microsoft Corporation. All rights reserved.