Microsoft KB Archive/190760

= FIX: Data View Stops After Typing in an Invalid Name =

Article ID: 190760

Article Last Modified on 3/7/2005

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q190760



SYMPTOMS
In the DataEnvironment (DE) Command property page, if the user types in an incorrect Stored Procedure name, and clicks OK to the property page, the data view will stop working.



CAUSE
This is a problem in the SQL Server 6.5 being unable to handle information requests for non-existent Stored procs.



RESOLUTION
This has been fixed in SQL Server 6.5 (SP 5) and SQL Server 7.0.

The user can work around this by using the refresh command on the DataEnvironment (the node under Global.asa) node in the project Explorer. The user can then relogin to their database, which will cause the data view to start working.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

This bug was corrected in Visual Studio 6.0 Service Pack 3.

For more information about Visual Studio service packs, please see the following articles in the Microsoft Knowledge Base:

Q19402 INFO: Visual Studio 6.0 Service Packs, What, Where, Why

194295 HOWTO: Tell That Visual Studio 6.0 Service Packs Are Installed



Steps to Reproduce Behavior

 * 1) Create a Web project and add a connection to SQL Server.
 * 2) From the Project menu, select Add data command.
 * 3) In the Command property page, set object type to be stored procedure.
 * 4) Type in an invalid stored proc name and press RETURN, dismissing the property page.

Keywords: kbbug kbfix kbide kbvs600sp3fix KB190760

-

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

© Microsoft Corporation. All rights reserved.