Microsoft KB Archive/202883

= FIX: Multiple Datasources Deletes Client Config Utility Advanced Entry =

Article ID: 202883

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft ODBC Driver for Microsoft SQL Server 3.5
 * Microsoft ODBC Driver for Microsoft SQL Server 3.6

-



This article was previously published under Q202883



SYMPTOMS
Creating multiple datasources that reference a single client configuration utility advanced entry will cause the advanced entry to be deleted.

When attempting to connect to that server you will receive the following message:

"Connection failed: SQLState: '08001' SQL Server Error: 6 [Microsoft][ODBC SQL Server Driver][DBNMPNTW]Specified SQL server not found. Connection failed: SQLState: '01000' SQL Server Error: 53 [Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen(CreateFile)."



CAUSE
SQL Server ODBC Driver versions 3.50.0303, 3.50.0305, 3.50.0315 or 3.60.0310 exhibit this behavior.



RESOLUTION
Upgrade the SQL Server driver to 3.60.0319 or later, or work around the problem by re-creating the advanced entry. Click the Client Configuration button in the Microsoft SQL Server DSN Configuration wizard, which runs the SQL Server Client Configuration utility.



STATUS
Microsoft has confirmed that this is a problem in the SQL Server ODBC Driver version 3.50.3609.

This problem was corrected in SQL Server ODBC Driver release 3.60.0319.

For more information, contact your primary support provider.

Keywords: kbbug kbfix kbdatabase KB202883

-

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

© Microsoft Corporation. All rights reserved.