Differences between revisions 3 and 4
Revision 3 as of 2008-12-31 06:57:43
Size: 1855
Comment: Added comments to pyodbc. Moved win32odbc to bottom; it is the last library most people should use (buggy, out of date, and no longer supported)
Revision 4 as of 2010-08-19 19:55:40
Size: 2486
Editor: ip-62-143-153-202
Comment:
Deletions are marked like this. Additions are marked like this.
Line 12: Line 12:
  License:: eGenix Commercial License
  Platforms:: Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
  Python versions:: 2.3 - 2.6
  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.

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

mxODBC Connect

URL

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

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

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.

ODBC (last edited 2017-08-07 22:47:25 by MaximilianFuxjaeger)

Unable to edit the page? See the FrontPage for instructions.