Microsoft KB Archive/190944

= BUG: Recordset DTC Using Stored Procedure Fails to Load =

Article ID: 190944

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q190944



SYMPTOMS
The user previews a page containing a Recordset Design-time control (DTC) and gets a blank white page.



CAUSE
This bug is caused by attempting to use a server-side cursor when running a stored procedure that returns multiple result sets.



RESOLUTION
One option is to change the recordset DTC to use client-side cursors instead of server-side cursors. In some cases, removing the "return" statement from the stored procedure may also work to resolve the issue.



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

 * 1) Create new Web project.
 * 2) Add a dataconnection.
 * 3) Add new ASP page.
 * 4) Drag a recordset DTC to the page.
 * 5) Set the DTC to use an SP as the datasource (the SP should contain a 6. Simple select statement and a return statement).
 * 6) Set the DTC to use server-side cursor (Advanced tab on the prop page).
 * 7) Type in some basic HTML text in the ASP page.
 * 8) Preview the file.

Keywords: kbbug kbstoredproc kbdatabase kbctrl kbpending KB190944

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.