ODBC

ODBC stands for Open Database Connectivity, the industry standard for database C APIs.

Most databases ships with ODBC drivers, so chances are high that you can use one of these drivers together with a Python ODBC interface to connect your Python application with any database on the market.

DB API 2.0 Drivers

mxODBC

URL

http://www.egenix.com/products/python/mxODBC/

License

eGenix Commercial License 1.3.0

Platforms

Windows 32/64-bit, Linux 32/64-bit, MacOS X 10.4-10.6 32/64-bit, FreeBSD 32/64-bit, Solaris, AIX

Python versions

2.3 - 2.7

Commercially supported ODBC database interface from eGenix.com; actively maintained since 1997.

Supports Windows, Mac OS X, iODBC, unixODBC and DataDirect ODBC driver managers. Is known to work with these ODBC drivers: MS SQL Server Native Client, MS SQL Server ODBC Driver, FreeTDS ODBC Driver, Oracle Instant Client ODBC Driver, IBM DB2 ODBC Driver, Sybase ASE ODBC Driver, Netezza ODBC Driver, Teradata ODBC Driver, PostgreSQL ODBC Driver, MySQL ODBC Driver, .MaxDB ODBC Driver as well as the ODBC driver sets of EasySoft, DataDirect, OpenLink, Actual Technologies.

pyodbc

URL

http://code.google.com/p/pyodbc

License

MIT

Platforms

Windows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided)

Python versions

2.4 - 2.6

Actively maintained Open Source project.

Precompiled binaries are available for Windows. RedHat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories.

ceODBC

URL

http://ceodbc.sourceforge.net

License

Platforms

Windows

Python versions

ODBTPAPI

URL

http://benjiyork.com/odbtp.html

License

Platforms

Python versions

win32 odbc

URL

http://python.net/crew/mhammond/win32/

License

PSF and others

platforms

Windows

Python versions

This interface is rather old and unmaintained, but listed here since it started the Python DB-API specification development.