Article ID: 238091
Article Last Modified on 3/14/2006
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft SQL Server 6.5 Service Pack 5a
This article was previously published under Q238091
SYMPTOMS
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.
CAUSE
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.
RESOLUTION
Do 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.
WORKAROUND
The Cliconfg.dll and Cliconfg.exe files that are installed by SQL Server 7.0 SP2 fix the problem.
STATUS
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:
254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.
MORE INFORMATION
Steps to Reproduce Behavior
Using SQL Server 6.5 Client Configuration Utility perform the following steps:
- Go to the Net Library tab and set the Default Network to Named.
Go to the Advanced tab and create two entries:
entry#1 : dbmssocn, <ip-address1>,1433 entry#2 : dbmssocn, <ip-address2>,1433
Using the ODBC Administrator version 3.510.3513 or higher with SQL Server ODBC driver version 3.70.0623 perform this step:
Go to the System DSN tab and click Add. While configuring the DSN, click Client Configuration and create a new entry for sockets using the name that was entered in the Server field. The correct TCP/IP address and port number should be entered so that the DSN can be successfully created.
entry#3 : dbmssocn, <ip-address3>, <port3>After you complete these steps, when you run the ClientConfig utility again, you will see that only entry3 exists in the Advanced tab. Previously existing entries entry#1 and entry#2 are missing when viewed from the Registry editor (regedt32) under the following:
HKLM_LM\Software\Microsoft\MSSQLServer\Client\ConnectTo HKLM_LM\ Software\Microsoft\MSSQLServer\Client\TDS
Keywords: kbbug kbfix KB238091
