To determine whether client-side or server-side scrollable cursors are used, you must set the UseCursor property:
When the UseCursor connection property is set to 1, server-side scrollable cursors are used, if the ASE version is 15.0 or later. For earlier versions of the ASE server, server-side scrollable cursors is not available.
When the UseCursor connection property is set to 0, client-side scrollable cursors (cached result sets) are used, regardless of the ASE version.
WARNING! Using client-side scrollable cursors is resource intensive.
