PyADO

• Description
• Related Projects
• Sourceforge Links
• Contributors
• News
• Status
• Quick Start and Sample Code

PyADO is a Python DB-API 2.0 compliant interface to Microsoft's ActiveX Data Objects.

This allows a connection to any OLE DB driver/database using standard DB-API code.

PyADO is written entirely in Python, and uses the Python for Windows extensions to interface with COM.

Although it is also possible to use ADO directly from Python, with the Windows extensions, this driver allows code written to use DB-API 2.0 to use ADO, which means that this code will be portable to other Python database drivers.

The source code is licensed under the Python license (Python Software Foundation version).

• Python
• Python Database Topic Guide
• Other Python Database Modules
• Python Database API Specification v2.0
• Python for Windows extensions
• Python and ADO
• ADOdb.py, another Python-ADO driver

PyADO is hosted by SourceForge. Here are the various relevant pages...

• PyADO Home Page (this page)
• Project Page
• CVS Access instructions
• Browse CVS Repository
• Project Downloads

There are three mailing lists for PyADO. Please use the appropriate one for any questions.

• Low-volume Announcements (or see the archives)
• Users Mailing List (or see the archives)
• Developers Mailing List (or see the archives)

PyADO was created by David Fraser and Shayan Raghavjee of St James Software.

Any additional contributions are welcome, and will be listed here. Please use the mailing lists or contact the project admin (David Fraser) through the project page.

2002-08-20: The project has been created and release 0.1 is available for download...

2002-08-20: The project is being created...

PyADO and DB-API 2.0 requirements:

• module interface: supported
• errors and exceptions: still uses standard COM errors, need to override
• connection object: still needs commit and rollback
• cursor object: needs parameters, rowcount, callproc, setinputsizes, setoutputsizes
• type objects: uses constants, needs proper type hierarchy

PyADO has been used successfully on:

• python versions: Python 2.2
• databases: Oracle 8.0.5, Oracle 8i, MSDE 7.0, Microsoft SQL Server 7.0, Microsoft Access 2000
• operating systems: Windows 2000
• ADO versions:ADO 2.5

If you have any problems on a different system, or get PyADO working, please let us know

This assumes you have ADO and the database installed. Download and install the following:

• Python 2.2.1 for Windows
• Python Win32 Extensions 148 for Python 2.2

Then download PyADO from the downloads page above. Assuming you installed Python into C:\Python22, a good place to put the PyADO.py module so its always available is in C:\Python22\Lib\site-packages.

Test the installation: Run Python and try and import the module:

import PyADO

Try connect to a database:

conn = PyADO.connect(None,user='admin',password='',host=None,database='C:\\test.mdb',provider='Microsoft.Jet.OLEDB.4.0')

This example connects to an Access database in C:\test.mdb. Note that host should be set to None unless you are using SQL Server... Also note that you need to pass the OLE DB provider name as a parameter to connect

Now you need a cursor to execute statements on:

curs = conn.cursor()

Now let's run a SQL statement (you will need to put a useful statement here):

curs.execute("select * from some_table")

Finally let's display the data

result = curs.fetchall()
descr = curs.description
for col in descr:
    print col[0],
print
for row in result:
    for col in row:
        print col,
    print

You can disconnect as well:

curs.close()
conn.close()