PRB: CursorType Returns adOpenStatic from Server-Side Recordset and Behaves Like a Forward-Only Recordset (306388)
The information in this article applies to:
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
- Microsoft SQL Server 7.0
- ActiveX Data Objects (ADO) 2.6
- ActiveX Data Objects (ADO) 2.7
- Microsoft SQL Server 2000 (all editions) 8.0
- Microsoft SQL Server 2000 (all editions) SP1
This article was previously published under Q306388 SYMPTOMS
If you request a static, server-side cursor from a SQL stored procedure, you cannot use MovePrevious or MoveFirst to move backward through the recordset. The cursor exhibits the behavior of a forward-only cursor. NOTE: This problem only occurs if there are user-defined variables in the stored procedure or SQL commands such as SET NOCOUNT ON.
After you run MovePrevious or MoveFirst, you receive the following error message:
Run-time error '-2147217884(80040e24)';
Rowset does not support fetching backward.
REFERENCESFor additional information, click the article numbers below
to view the articles in the Microsoft Knowledge Base:
123008 HOWTO: Set Up ODBC Data Sources When Distributing Apps
171146 HOWTO: Create and Remove a DSN in Visual Basic
306385 PRB: CursorType Returns adOpenStatic When You Request adOpenDynamic from a Server-Side Recordset
Modification Type: | Major | Last Reviewed: | 5/8/2003 |
---|
Keywords: | kbpending kbprb KB306388 |
---|
|