Installation guide

mxODBC - Python ODBC Database Interface

1.2 Features

• Python Database API 2.0 Compliance: the mxODBC API is fully Python

DB-API 2.0 compatible and implements a large number of powerful

extensions.

• Support for all recent ODBC Version : mxODBC works with ODBC

drivers implementing the ODBC version specifications 2.0 - 3.8.

• Uses ODBC 3 APIs: provided the ODBC driver/manager is capable of

using ODBC 3 APIs, mxODBC will use them for added efficiency.

• 32-bit and 64-bit ODBC: mxODBC supports both 32-bit and 64-bit

versions of the ODBC standard - including special 64-bit builds on Unix.

• Supports all major ODBC driver managers: mxODBC can work with the

MS ODBC Driver Manager on Windows, unixODBC, iODBC and the

DataDirect ODBC Driver Manager on Unix and the Mac OS X ODBC

Driver Manager on Mac OS X. If needed, multiple ODBC managers can

be used at the same time, giving you full flexibility.

• Stable, robust and reliable: the mxODBC API has been in active

production use since 1997.

• Stored Procedure / Function Calls: mxODBC support calling stored

procedures and functions, using output and input/output parameters, as

well as result sets for passing back data to Python.

• ODBC Catalog & Introspection Functions: mxODBC Client API provides

methods e.g. to list tables, find column specifications, query index

relationships, etc.

• Support for Multiple Result Sets: call stored procedures and access all

returned result sets using an easy to API. Easily free up resources in case

result sets are no longer needed.

• Support for custom Row objects: in addition to using standard Python

tuples, mxODBC can automatically return result set rows as custom

objects. mxODBC comes with a set of optimized row factories for:

TupleRows, ListRows and NamespaceRows. All of these provide both

index and attribute access to row column fields.

• Dynamic ODBC Configuration: adjust ODBC connection parameters

dynamically, e.g. set timeouts, read-only access, auto-commit, etc.

• Many useful DB-API Extensions:

o Adjustable .paramstyle: mxODBC supports both the ODBC

question mark positional parameter binding style as well as the

named parameter styles used by e.g. Oracle.