Python module that makes it easy to use Microsoft ADO for connecting with databases and other data sources. -- This module is included as part of pywin32. _BUT_ there is a packaging error in pywin32 v219 so you MUST DOWNLOAD FROM HERE until that is fixed!
* Documentation ah or quick_reference.odb in the .zip


  • Tested using ACCESS, MS SQL Server, MySQL and PostgreSQL
  • can retrieve SQL data by column name or number.
  • can change paramstyle to 'qmark', 'format', 'named', 'pyformat'..
  • New in version 2.5: LINUX remote, Windows server, more extensions

Project Samples

Project Activity

See All Activity >

Follow Python DB-API 2.0 module for ADO

Python DB-API 2.0 module for ADO Web Site

Other Useful Business Software

Find out what (or who) is slowing down your network Icon
Find out what (or who) is slowing down your network Icon

Get comprehensive network bandwidth analysis and performance monitoring with SolarWinds® Bandwidth Analyzer Pack.

Network slow, but you don't know the cause? Use Bandwidth Analyzer Pack (BAP) to monitor and analyze network bandwidth performance and traffic patterns. With BAP, you can identify which users, applications, and protocols are consuming the most bandwidth. You can also monitor Wireless LAN Controller traffic to see what applications and clients are using your wireless network. Try it free for 30 days!

Rate This Project

Login To Rate This Project

User Ratings

ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5

User Reviews

  • Some nice features (e.g., named column retrieval from recordsets) and a few bugs. The biggest problem is that this page doesn't appear to give any clues that the project has moved to GitHub (search for mhammond and pywin32 -- SourceForge won't let me post a link in this review, which I only filed so I could let others avoid wasting their time here, as I have). Don't bother filing bug reports or other support requests here. :-)

Read more reviews >

Additional Project Details

Intended Audience


Programming Language


Database Environment

Project is a database abstraction layer (API), Python Database API, MySQL, PostgreSQL (pgsql), IBM DB2, Microsoft SQL Server, Microsoft Access, ODBC, ADOdb