Error Clicking Back Button After Testing New DSN in ODBC Control Panel (234224)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft ODBC Driver for SQL Server 3.7
This article was previously published under Q234224

SYMPTOMS

After you go through the steps to create a new data source name (DSN), if you click the Back button after you test the connection, you receive the following error message:
An error occurred while Windows was working with the Control Panel file c:\winnt\system32\odbccp32.cpl.
The error message only occurs if, while you create the DSN, you clear the Connect to SQL Server to obtain default settings for the additional configuration options check box. This problem occurs with the 3.70.06.23 version of the SQL Server driver, which was included with SQL Server 7.0.

WORKAROUND

To work around this problem, use either of these methods:
  • Do not click the Back button after you test a new DSN; click Finish instead.

    -or-

  • Do not disable the Connect to SQL Server to obtain default settings for the additional configuration options option when you create the DSN. If you do click Back and the error message described in the "Symptoms" section occurs, you must re-create the DSN.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

232570INF: How to Obtain Service Pack 1 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 the Problem

  1. In Control Panel, double-click the ODBC Data Sources icon.
  2. On the User DSN tab, click Add.NOTE: The problem also occurs with the System and File DSNs as well.

  3. Click to select the SQL Server driver, and then click Finish.
  4. Fill in the appropriate text boxes for the new DSN, including the information for the DSN name, description, and the server to which you will connect. Click Next.
  5. In the next screen, enable Microsoft Windows NT authentication, and then clear the Connect to SQL Server... check box.
  6. Click Next twice, and then click Finish.
  7. Click Test Data Source. The test should complete successfully. Click OK.
  8. Click Cancel, and then click Back. The error occurs.
Modification Type:MajorLast Reviewed:3/14/2006
Keywords:kbBug kbfix kbSQLServ700sp1fix KB234224
©2004 Microsoft Corporation. All rights reserved.