Microsoft KB Archive/165807

= BUG: Web Server Hangs When Updating a Stored Procedure in SQL =

Article ID: 165807

Article Last Modified on 5/2/2006

-

APPLIES TO


 * Microsoft Visual InterDev 1.0 Standard Edition

-



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.



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 

<div class="references_section">