This method of the Connection class returns the location of the cursor service.
public int getCursorLocation();
Returns an integer representing cursor service location.
This method allows you to choose between various cursor libraries accessible to the provider. Usually, you can choose between using a client-side cursor library or one that is located on the server.
This CursorLocation value affects connections established only after the property has been set. Changing the CursorLocation value has no effect on existing connections.
This property is read/write on a Connection or a closed Recordset, and read-only on an open Recordset.
Cursors returned by the execute method inherit this setting. Recordsets will automatically inherit this setting from their associated connections.
Remote Data Service Usage When used on a client-side Recordset or Connection object, CursorLocation can only be set to CLIENT.