FIX: Data View Stops After Typing in an Invalid Name

ID: Q190760


The information in this article applies to:


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 this to be a bug in the Microsoft products 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

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


MORE INFORMATION

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.


Additional query words:


Keywords          : kbide kbVisID600bug kbGrpASP kbSQLServ650bug kbVS600sp3fix 
Version           : WINDOWS:6.0; winnt:6.5
Platform          : WINDOWS winnt 
Issue type        : kbbug 

Last Reviewed: May 24, 1999