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:
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.
Keywords: kbbug kbfix kbide kbvs600sp3fix KB190760
