Microsoft KB Archive/234224

= Error Clicking Back Button After Testing New DSN in ODBC Control Panel =

Article ID: 234224

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft ODBC Driver for Microsoft 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.



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.


 * 1) Click to select the SQL Server driver, and then click Finish.
 * 2) 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.
 * 3) In the next screen, enable Microsoft Windows NT authentication, and then clear the Connect to SQL Server... check box.
 * 4) Click Next twice, and then click Finish.
 * 5) Click Test Data Source. The test should complete successfully. Click OK.
 * 6) Click Cancel, and then click Back. The error occurs.

Additional query words: err msg av access violation ctrl cntrl cont pan pnl CP

Keywords: kbbug kbfix kbsqlserv700sp1fix KB234224

-

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

© Microsoft Corporation. All rights reserved.