Server Cursor Property

ADO and SQL Server

ADO and SQL Server

Server Cursor Property

The Server Cursor property determines where a cursor, if required, is materialized.

Applies To
Command Object Recordset Object
Syntax

object.Properties("Server Cursor") [= value]

Parts

object

Expression that evaluates to an object in the Applies To list.

value

Boolean that determines whether a cursor is materialized on the server or on the client, as specified in Settings.

Settings
Value Description
True The provider attempts to support any requested cursor functionality by materializing a cursor on the server.
False The provider attempts to support any requested cursor functionality by materializing a cursor on the client.

Data Type

adBoolean

Modifiable

Read/write

OLE DB Property

DBPROP_SERVERCURSOR