Set ODBC_CURSOR_TYPE to one of the following to specify a cursor type to use:
| For cursor type ... | Set ODBC_CURSOR_TYPE to ... |
|---|---|
| SQL_CURSOR_FORWARD_ONLY | 0 |
| SQL_CURSOR_KEYSET_DRIVEN | 1 |
| SQL_CURSOR_DYNAMIC | 2 |
| SQL_CURSOR_STATIC | 3 |
For example:
ODBC_CURSOR_TYPE 3
sets the cursor type to a static cursor.
On Windows, the default is 3 (static). On other systems, the default is the driver default.
Note that not all cursor types are supported by all drivers or in all circumstances. Therefore, you are encouraged to check your database and operating system documentation before using this variable.