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

• Microsoft Visual InterDev, version 1.0

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/

Additional query words:

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