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

nel_h2
Gen AI apps are built with MongoDB Atlas Icon
Gen AI apps are built with MongoDB Atlas

The database for AI-powered applications.

MongoDB Atlas is the developer-friendly database used to build, scale, and run gen AI and LLM-powered apps—without needing a separate vector database. Atlas offers built-in vector search, global availability across 115+ regions, and flexible document modeling. Start building AI apps faster, all in one place.
Start Free
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

Be the first to post a review of Python DB-API 2.0 module for ADO!

Additional Project Details

Operating Systems

Windows

Intended Audience

Developers

Programming Language

Python

Database Environment

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

Related Categories

Python Database Software, Python Software Development Software

Registered

2002-09-26