Article ID: 238091 - View products that this article applies to.
This article was previously published under Q238091
This article has been archived. It is offered "as is" and will no longer be updated.
Existing SQL Server advanced entries are deleted when the server name that is the same as the advanced entries is added or edited from the ODBC administrator during a data source name (DSN) configuration.
This problem may occur in the SQL Server ODBC driver version 3.70.0623 or later. The earlier versions of the SQL Server ODBC driver allow you to create the advanced entries without deleting existing entries.
When a DSN is created with the SQL Server ODBC Driver version 3.60.0319 or earlier, clicking Client Configuration opens the SQL Server 6.5 Client Configuration Utility (WindbVer.exe), which is used to set up and modify advanced entries.
With the 3.70.0623 version of the SQL Server ODBC driver a new client utility interface was introduced and the new client utility is causing the problem to occur.
RESOLUTIONDo not create advanced entries when a DSN is being configured using the SQL Server ODBC Driver unless the SQL Server 7.0 Service Pack 2 (SP2) client components are installed on the computer.
The Cliconfg.dll and Cliconfg.exe files that are installed by SQL Server 7.0 SP2 fix the problem.
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561For more information, contact your primary support provider.
(http://support.microsoft.com/kb/254561/ )INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
Steps to Reproduce BehaviorUsing SQL Server 6.5 Client Configuration Utility perform the following steps: