Installation guide

1. Introduction
o cursor.scroll() to scroll the cursor in result sets without actually
fetching data.
o cursor.prepare() to prepare SQL statements for execution,
without actually running them. This allows creating pools of
cursors for dedicated purposes.
o connection.autocommit to easily turn on/off the ODBC
autocommit feature
o cursor and connection objects usable as context managers
o cursor.executemany() accepts iterators/generators as parameter
"sequence".
o cursor.cursortype to easily adjust the used ODBC cursor type to
your application's needs.
o ODBC cursor/connection option methods to adjust ODBC
cursors/connections to your application's needs and optimize
performance by e.g. declaring a connection read-only.
• Configurable Data Type Mappings:
o Supports Python type binding and Database type binding for
efficient data exchange.
o Supports mxDateTime and Python's time and datetime modules
for date/time value exchange.
o Supports standard Python floats, integers, longs and Python's
decimal module for loss-less numeric value exchange.
o Supports Python 2.7 memoryview objects.
o Automatically handles and supports unknown data types and
user data types via string conversion.
• Full Unicode Support: use Unicode for managing text data in your client
applications - even if the database does not natively support Unicode,
mxODBC will automatically provide the necessary conversions on-the-fly.
mxODBC supports both the Unicode or the ANSI ODBC APIs. You can
chose the optimal approach for your driver.
• Multi-Version Python Support: mxODBC works with Python 2.4, 2.5, 2.6
and 2.7.
1
• Full 64-bit Support: mxODBC runs on the following 64-bit platforms
natively: Windows, Linux, FreeBSD and Mac OS X.
1
Please note that mxODBC 3.3 will be the last release to support Python 2.4, 2.5 and 2.6.
The next release will only support Python 2.7 and Python 3.
3