Differences between revisions 30 and 31
Revision 30 as of 2013-02-17 05:55:52
Size: 3753
Editor: jiangwen365
Comment:
Revision 31 as of 2013-02-17 11:41:41
Size: 3715
Comment: Fix formatting. Add Wikipedia link to ODBC article.
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:

ODBC stands for ''Open Database Connectivity'', the industry standard for database C APIs.
[http://en.wikipedia.org/wiki/Odbc ODBC] stands for ''Open Database Connectivity'', the industry standard for database C APIs.
Line 9: Line 7:
Line 11: Line 8:


Line 17: Line 11:
Line 19: Line 12:
Line 28: Line 20:
Line 30: Line 21:
Line 34: Line 24:
Line 36: Line 25:
Line 45: Line 33:
Line 47: Line 34:
Line 51: Line 37:
Line 53: Line 38:
Line 62: Line 46:
Line 64: Line 47:
Line 73: Line 55:
Line 75: Line 56:
Line 79: Line 59:
Line 82: Line 61:
Line 84: Line 62:
Line 93: Line 70:
Line 95: Line 71:
Line 104: Line 79:

 *
One pure Python script, runs on CPython / IronPython / PyPy , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit
 * Almost totally same usage as pyodbc ( can be seen as a re-implementation of pyodbc in pure Python )
 * Simple - the whole module is implemented in a single python script with less than 3000 lines
 * Built-in Access MDB file creation and compression functions on Windows
One pure Python script, runs on CPython / IronPython / PyPy , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit.
Almost totally same usage as pyodbc ( can be seen as a re-implementation of pyodbc in pure Python ).
Simple - the whole module is implemented in a single python script with less than 3000 lines.
Built-in Access MDB file creation and compression functions on Windows.
Line 113: Line 86:


Line 118: Line 88:
Line 120: Line 89:
Line 129: Line 97:

ODBC

[http://en.wikipedia.org/wiki/Odbc ODBC] stands for Open Database Connectivity, the industry standard for database C APIs.

Most databases ship 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 - 3.2

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 1.3.0
Platforms
Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
Python versions
2.5 - 2.7

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. The product uses mxODBC on the server side and provides a highly portable Python library for the client side. As such it supports all database backend that mxODBC supports, but allows connecting to these from many different Python-supported platforms.

For ODBC drivers supported on the server side, please see the mxODBC entry.

The 2.0 release also supports asynchronous query execution via the popular gevent package.

ODBTPAPI

URL

http://benjiyork.com/odbtp.html

License
Platforms
Python versions

PyPyODBC

URL

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

License
MIT
Platforms
Windows, Linux
Python versions
2.4 - 2.7

One pure Python script, runs on CPython / IronPython / PyPy , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit. Almost totally same usage as pyodbc ( can be seen as a re-implementation of pyodbc in pure Python ). Simple - the whole module is implemented in a single python script with less than 3000 lines. Built-in Access MDB file creation and compression functions on Windows.


DB API 1.0 Drivers

win32 odbc module (part of pywin32 package)

URL

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

License
PSF and others
platforms
Windows
Python versions
2.3 - 3.2

This interface is rather old, mostly unmaintained and only provides an DB-API 1.0 interface, but listed here since it started the Python DB-API specification development back in 1996.

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

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