FIX: Data View Stops After Typing in an Invalid Name (190760)

The information in this article applies to:

Microsoft Visual InterDev 6.0
Microsoft SQL Server 6.5

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

MORE INFORMATION

Steps to Reproduce Behavior

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

Modification Type:	Minor	Last Reviewed:	3/7/2005
Keywords:	kbBug kbfix kbide kbVS600sp3fix KB190760