ADODB Object

CursorLocation

 
Syntax
 
CursorLocationEnum = recordsetobject.CursorLocation
recordsetobject.CursorLocation = CursorLocationEnum
 
Description
Sets or returns a long value that is a CursorLocationEnum value which defines the location of the cursor engine (server-side or client-side).
The CursorLocation property sets or returns one of the CursorLocationEnum constants that specifies the location of the cursor library. In reality, there are only two choices, client-side or server-side. Typically, client-side cursors are more versatile. However, the default is to the server-side.
 
You cannot change the cursor library for a Recordset while it is open.
 
CursorLocationEnum Constants 
 
 
Constant
Value
Description
adUseClient
3
Use client-side cursor supplied by the local cursor library
adUseClientBatch
3
Obsolete, same as adUseClient
adUseNone
1
Obsolete, no cursor service
adUseServer
2
Default, use the cursor supplied by provider or database
See Also
Connection, Connection.Execute, Recordset, CursorType.
Example
 
Set objRecordset = Server.CreateObject("ADODB.Recordset")
Set objRecordset.ActiveConnection = strConnection
objRecordset.CursorLocation = adUseClient
objRecordset.CursorType = adOpenDynamic
...
objRecordset.Open "ChantList", , , , adCmdTable