Working with Cursor and Lock Type Combinations

The cursor and lock type combinations that are supported by the SAS providers depend on whether the cursor is located on the client side or the server side. If you request a combination that is not supported, then the providers will attempt to use the supported combination that most closely matches your choice. After the recordset is opened, verify the cursor and lock type.

When you specify properties and cursor location on a recordset, you must specify the properties after the cursor location is set. Certain properties can be specified only for the server. If the cursor location is specified after the properties, you might not see an error and you might have unexpected results. For more information, see the discussion of SAS customized properties in Known Issues for All Providers.