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

ID: Q165807

The information in this article applies to:

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

  1. Insert connection to SQL 4.2 into a Web Project.


  2. Create a Stored Procedure that selects all from a table, for example: Create Procedure selAuthors As Select * From Authors


  3. Create a new Active Server Page and add code to insert a new record in the ASP.


  4. 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/support/vinterdev/


Keywords          : kb3rdparty kbADO kbASP kbVisID kbVisID100 kbWebServer kbGrpASP VIServer 
Version           : WINDOWS:1.0
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: May 7, 1999