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
- License
- eGenix Commercial License
- Platforms
- Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
- Python versions
- 2.3 - 2.6
pyodbc
- URL
- 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
- License
- Platforms
- Windows
- Python versions
mxODBC Connect
- URL
- License
- eGenix Commercial License
- Platforms
- Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
- Python versions
- 2.3 - 2.6
mxODBC Connect is a commercial client-server product that allows connecting Python to ODBC compatible databases running on remote servers without requiring an ODBC driver on the client side.
ODBTPAPI
- URL
- License
- Platforms
- Python versions
win32 odbc
- URL
- 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.