Installation guide

6. mxODBC Connection Objects
.cursortype
Read/write attribute that sets the default ODBC cursor type for cursors created
on this connection. Possible values are:
SQL.CURSOR_FORWARD_ONLY
The cursor only scrolls forward. This is the default setting for all
databases.
12
SQL.CURSOR_STATIC
The result set is made static by creating a static copy of the result set after
opening the cursor. As a result, any changes to the result set after opening
the cursor will not be visible to the client.
12
SQL.CURSOR_KEYSET_DRIVEN
Keysets are sets of columns in the result set that provide unique keys to the
rows in the result set. Keyset driven cursors fix the memberships and order
of the rows in the result set using these keysets. Unlike static cursors, they
don't create a copy of the result set.
SQL.CURSOR_DYNAMIC
Dynamic cursors are the opposite of static cursors. All changes to the result
set after opening it are visible on the next fetch operation.
Please refer to section 5.8 ODBC Cursor Types for more details on cursor
types. Not all databases support all listed cursor types.
Performance Warning:
Please note that using cursor types other than SQL.CURSOR_FORWARD_ONLY
may have a significant effect on the performance of fetch operations.
.datetimeformat
Use this instance variable to set the default output format for
date/time/timestamp columns of all cursors created using this connection
object.
Possible values are (see the Constants
section 10.5 for details):
DATETIME_DATETIMEFORMAT (default)
DateTime and DateTimeDelta instances.
PYDATETIME_DATETIMEFORMAT
datetime.date, datetime.time, datetime.datetime instances. Only
available using Python 2.4 and later.
TIMEVALUE_DATETIMEFORMAT
Ticks (number of seconds since the epoch) and tocks (number of
seconds since midnight).
12
Please note that in mxODBC 3.2, the default was database dependent.
95