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 Adaptive Server version is 15.0 or later. In earlier versions of the Adaptive Server, server-side scrollable cursors are not available.
When the UseCursor connection property is set to 0, client-side scrollable cursors (cached result sets) are used, regardless of the Adaptive Server version.
WARNING! Using client-side scrollable cursors is resource-intensive.
