FIX: SQL Server 2000 ODBC Driver fails to return SQL Server 7.0 server names on client computers that have MDAC 2.6 installed (299765)
The information in this article applies to:
- Microsoft Data Access Components 2.6
- Microsoft ODBC Driver for SQL Server 2000 2000.80.194
This article was previously published under Q299765 SYMPTOMS
From a client computer that has Microsoft Data Access Components (MDAC) 2.6 and SQL Server ODBC Driver version 2000.80.194, if you try to retrieve all of the server names by calling the SQLBrowseConnect() ODBC API function, you will not receive any SQL Server 7.0 (or earlier) server names. You will only receive the SQL Server 2000 server list.
CAUSE
A bug in this version of the SQL Server ODBC driver ignores all SQL Server 7.0 names as they are returned from the SQL Server netlibs.
RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft Data Access Components 2.6 or SQL Server 2000:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
300635 INFO: How to Obtain the Latest MDAC 2.6 Service Pack
For customers who are unable to upgrade to the latest service pack, a supported fix is available from Microsoft, but it is only intended to correct the problem described in this article and should be applied only to systems experiencing this specific problem.
To obtain the fix, contact Microsoft Product Support Services. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, please go to the following address on the World Wide Web:
NOTE: In special cases, charges that are normally incurred for support calls may be canceled, if a Microsoft Support Professional determines that a specific update will resolve your problem. Normal support costs will apply to additional support questions and issues that do not qualify for the specific update in question.
The English version of this fix should have the following file attributes or later:
Date Time Version Size File name Platform
-------------------------------------------------------------------
23-MAY-2001 17:12 2000.80.298.0 28,742 Odbcbcp.dll i386
23-MAY-2001 17:12 2000.80.298.0 471,119 Sqlsrv32.dll i386
23-MAY-2001 17:12 2000.80.298.0 90,112 Sqlsrv32.rll i386
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in SQL Server 2000 Service Pack 2 and MDAC 2.6 Service Pack 1.
Modification Type: | Minor | Last Reviewed: | 9/26/2005 |
---|
Keywords: | kbHotfixServer kbQFE kbBug kbfix kbMDAC260sp1Fix kbSQLServ2000preSP2Fix KB299765 kbAudDeveloper |
---|
|