Controlling Cursor Behavior
There are two models for specifying the behavior of a cursor:
ADO supports specifying only cursor types, not cursor behaviors.
ODBC supports specifying cursor behavior using either the cursor types or the cursor behaviors of scrollability and insensitivity.
OLE DB's cursor behavior model differs from both cursor behaviors and cursor types.
The SqlClient 2.0 managed client does not expose server side cursors.
Prior to Microsoft SQL Server version 7.0, the DECLARE CURSOR statement used to define Transact-SQL cursors supported only cursor behaviors of SCROLL and INSENSITIVE. In SQL Server 7.0 and greater, DECLARE CURSOR was extended to support cursor-type keywords.
Do not specify both cursor types and cursor behaviors for a cursor. Use one or the other. Because ODBC and Transact-SQL cursors support both cursor behaviors and cursor types, use either ODBC or Transact-SQL when defining the cursor. The ODBC specification states that specifying both cursor behaviors and cursor types can lead to unpredictable results.