Python DB-API 2.0 module for ADO

Use Microsoft ADO to read/write most data bases.

Brought to you by: ekelund, kf7xm, manfre

1 Review

Downloads: 1 This Week

Last Update: 2020-12-17

Download

Get an email when there's a new version of Python DB-API 2.0 module for ADO

Windows

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

Scalable Cloud APIs for Efficient PDF and eSign Workflows

Integrate high-performance PDF, eSign, and document generation capabilities into your platform. Built for developers, proven at scale.

Foxit provides a powerful suite of cloud-native APIs that help organizations automate, secure, and modernize document workflows. Built on scalable REST architecture, Foxit APIs enable developers to generate, convert, extract, sign, and display documents directly within applications—eliminating manual processes and accelerating digital operations.

Learn More

Rate This Project

User Ratings

4.0 out of 5 stars

★★★★★

★★★★

★★★

★★

★

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

Filter Reviews:

All

bkline Posted 2018-02-17

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. :-)

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

Similar Business Software

Odoo

Odoo is a fully integrated, customizable, open-source software packed with hundreds of expertly designed business applications. Odoo’s intuitive database is able to meet a majority of business needs, such as: CRM, Sales, Project, Manufacturing, Inventory, and Accounting, just to name a few. Odoo...

See Software
Apify

Apify is a full-stack web scraping and automation platform helping anyone get value from the web. At its core is Apify Store, a marketplace with over 10,000 Actors where developers build, publish, and monetize automation tools. Actors are serverless cloud programs that extract data, automate...

See Software
DbVisualizer

DbVisualizer is a universal database client for anyone who works with data, from solo developers and startups to professional teams managing complex environments, including developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It offers a graphical interface...

See Software
Google Cloud SQL

Fully managed relational database service for MySQL, PostgreSQL, and SQL Server with rich extension collections, configuration flags, and developer ecosystems. New customers get $300 in free credits to spend on Cloud SQL. You won’t be charged until you upgrade. Reduce maintenance costs with...

See Software
SurveyJS

SurveyJS is an embeddable, self-hosted, white-label form builder for teams building custom forms, surveys, questionnaires, and other data collection tools inside web applications. It runs entirely on the client and is fully compatible with all modern JavaScript frameworks, including React,...

See Software
Teradata VantageCloud

Teradata VantageCloud: The complete cloud analytics and data platform for AI. Teradata VantageCloud is an enterprise-grade, cloud-native data and analytics platform that unifies data management, advanced analytics, and AI/ML capabilities in a single environment. Designed for scalability and...

See Software

Report inappropriate content

Scalable Cloud APIs for Efficient PDF and eSign Workflows

Integrate high-performance PDF, eSign, and document generation capabilities into your platform. Built for developers, proven at scale.

Learn More

Recommended Projects

Python for Windows Extensions
OLD project page for the Python extensions for Windows
Pyk8055 Python module
A Python module to seamlessly interact with the Velleman K8055 kit via the K8055D.dll for Windows using Python ctypes
PyCLIPS Python Module
Python module to interface the CLIPS expert system shell library.
libdxfrw
library to read dwg & read/write dxf files
Sybase module for Python
This Sybase module provides a Python interface to the Sybase relational database system. The Sybase package supports all of the Python Database API, version 2.0 with extensions.