The 3.2.0 release of our mxODBC is a new release of our popular Python ODBC Interface for Windows, Linux, Mac OS X and FreeBSD.
New Features in 3.2
Switched to unixODBC 2.3.1+ API: mxODBC is now compiled
against unixODBC 2.3.1, which finally removes the problems with the ABI
change between 2.2 and 2.3 by switching to a new library version
mxODBC connection objects can now be used as context managers to implicitly commit/rollback transactions.
mxODBC cursor objects can now be used as context managers to implicitly close the cursor when leaving the block (regardless of whether an exception was raised or not)
mxODBC added support for adjustable .paramstyles. Both 'qmark' (default) and 'named'
styles are supported and can be set on connections and cursors. The
'named' style allows easier porting of e.g. Oracle native interface code
mxODBC now supports a writable connection.autocommit attribute to easily turn on/off the connection's auto commit mode.
mxODBC added support for adjustable TIMESTAMP precision via the new connection/cursor.timestampresolution attribute.
mxODBC will round to nearest nanosecond fraction instead of
truncating the value. This will result in fewer conversion errors due to
floating point second values.
mxODBC's connect APIs Connect() and DriverConnect() support
setting connection options prior to connecting to the database via a new
connection_options parameter. This allows enabling e.g. the MARS feature in SQL Server Native Client.
The connection.cursor() constructor now has a new cursor_options parameters which allows configuring the cursor with a set of cursor options.
The .scroll() method supports far more ODBC drivers than before.
Updated the SQL lookup object to include more ODBC SQL parameter codes, including special ones for SQL Server and IBM DB2.
mx.ODBC.Manager will now prefer unixODBC over iODBC.
Previous mxODBC releases used the order iODBC, unixODBC, DataDirect
when looking for a suitable ODBC manager on Unix platforms. unixODBC is
more widely supported nowadays and provides better Unicode support than
The low-cost Standard Edition which provides data connectivity to a single database type, e.g. just MS SQL Server.
The Professional Edition, which gives full access to all mxODBC features.
The Product Development Edition, which allows including mxODBC in applications you develop.
Compared to mxODBC 3.0, we have simplified our license terms to clarify the
situation on multi-core and virtual machines. In most cases, you no
longer need to purchase more than one license per processor or virtual
machine, scaling down the overall license costs significantly compared
to earlier mxODBC releases.
For a complete overview of the available editions, please see the product page.
Users are encouraged to upgrade to this latest mxODBC release to benefit from the new features and updated ODBC driver support.
We have taken special care not to introduce backwards incompatible
changes, making the upgrade experience as smooth as possible.
For upgrade purchases, we will give out 20% discount coupons going
from mxODBC 2.x to 3.2 and 50% coupons for upgrades from mxODBC 3.x to
3.2. After upgrade, use of the original license
from which you upgraded is no longer permitted.
Please contact the eGenix.com Sales Team with your existing license serials for details for an upgrade discount coupon.