A Python module that makes it easy to use Microsoft ADO for connecting with databases and other data sources.
100% DB-API 2.0 compliant.
Includes pyunit testcases and examples describing how to use the module.
Fully implemented in Python.
Licensed under the LGPL license, which means that it can be used freely even in commercial programs subject to certain restrictions.
Tested using Microsoft SQL server, MySQL and Access (Jet) tables. Works with many others including AS/400.
Brief Documentation: quick_reference.pdf
Read more here.
Guilty Party (a.k.a. new project leader): Vernon Cole
Python 2.5 or higher.
Mark Hammond's pywin32 python for windows extensions. (Since pywin32 release 211, adodbapi is included, so you do not need to download it separately unless you want patches or are using IronPython.)
OR: IronPython version 2.6 or later.
The latest release may be found here .
The old adodbapi mailing lists are dead.
If you want to discuss or participate in developing adodbapi, subscribe to the pywin32 mailing list.
Original Author Henrik Ekelund.
Please send bug reports (preferably failing test cases), improvements and comments to the developers mailing list.
Information about connectionstrings can be found here.
The Python database SIG and related mailing list is here.
eGenix provides a high preformance commercial alternative if you want to use ODBC rather than ADO/OLE-DB.
Other database interfaces can be found here.