BUG: Web Server Hangs When Updating a Stored Procedure in SQL (165807)

The information in this article applies to:

Microsoft Visual InterDev 1.0

This article was previously published under Q165807

SYMPTOMS

Microsoft IIS will hang when updating or adding new records to a recordset returned by a stored procedure in Microsoft SQL Server version 4.2 and Sybase SQL Server.

RESOLUTION

There are no known workarounds at this time other than to use Microsoft SQL Server version 6.0 or 6.5 or an Oracle server.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

Insert connection to SQL 4.2 into a Web Project.
Create a Stored Procedure that selects all from a table, for example: Create Procedure selAuthors As Select * From Authors
Create a new Active Server Page and add code to insert a new record in the ASP.

Preview the ASP:

      Result : - Web Server Hangs.

      Sample Code to add new record:

      DataCommand1.AddNew
      DataCommand1("au_fname") ="H"
      DataCommand1("au_id") = "999-99-9987"
      DataCommand1("au_lname") = "P"
      DataCommand1("contract") = 0
      DataCommand1("phone") ="33644"
      DataCommand1.Update

REFERENCES

For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site:

http://support.microsoft.com/search/default.aspx?qu=vinterdev

Modification Type:	Major	Last Reviewed:	5/2/2006
Keywords:	kb3rdparty kbbug kbpending kbWebServer KB165807