Installation guide

mxODBC - Python ODBC Database Interface
3. Access Databases using mxODBC
mxODBC provides an easy to use way of accessing the ODBC API of ODBC
managers and drivers from Python. Together with a suitable ODBC driver installed
on the machine where you are running the Python application, you can connect to
your databases with a single Python call.
3.1 ODBC Application Stack
The typical ODBC application setup looks like this:
Python Application
↓
mxODBC
↓
ODBC Manager (Windows, unixODBC, iODBC, DataDirect)
↓
ODBC Driver
↓
(Network, Local Connection, Pipe, Shared Memory)
↓
Database
The upper blue part in the diagram executes within the process of the Python
application. The green part usually runs in a separate process and possibly also on
a different machine.
3.1.1 Architecture: 32-bit vs. 64-bit
As a result of this process setup outlined in the previous section, it is important
that you choose the right ODBC driver type for your application:
18