Python module that makes it easy to use Microsoft ADO for connecting with databases and other data sources.
For CPython users, this module is included as part of pywin32 (https://github.com/mhammond/pywin32), and continued support will take place there.
This fork will be maintained for Iron Python users.

* Documentation at http://adodbapi.sourceforge.net/quick_reference.pdf or quick_reference.odb in the .zip

Features

  • 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'..
  • Python3 version now fully integrated with pywin32.

Project Samples

Project Activity

See All Activity >

License

GNU Library or Lesser General Public License version 2.0 (LGPLv2)

Follow Python DB-API 2.0 module for ADO

Python DB-API 2.0 module for ADO Web Site

Other Useful Business Software
Everything Your Small Business Needs to Succeed | Connecteam Icon
Everything Your Small Business Needs to Succeed | Connecteam

Connecteam is an award-winning all-in-one employee management solution for daily operations, communications, and human resource management.

Easily engage and manage non-desk employees with Connecteam’s mobile-first platform that helps improve communication, enhance daily processes and increase productivity with custom checklists, forms, and reports. Schedule shifts and track accurate work hours with Connecteam’s automated GPS time clock and easily export approved timesheets to payroll. Connecteam helps you keep your employees sharp thanks to knowledge base centers and advanced training courses. Raise morale with employee recognition rewards and keep the entire company updated through the main news feed.
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
0
1
0
0
0
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

Operating Systems

Windows

Intended Audience

Developers

Programming Language

Python

Database Environment

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

Related Categories

Python Database Software, Python Software Development Software

Registered

2002-09-26