Thursday, October 15, 2009

ADOdb Database Abstraction Library for PHP (and Python) for MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Firebird, Interbase, LDAP, Access, VFP, DB2 and many other databases

CPython
Here is a list of resources for using the Adodb library to connect to an ODBC database. There are pieces of information that I found I had to combine all these sites to figure out

1. You have to add the mx library to your Python IDE or you can't use any of the functions in the ADOdb library.
2. ADOdb has no "move to the  first record in a returned Record set" method. I had to re-execute my sql string to move the cursor back to the first record.
3. The mx library from GENIX is not free. But you can get a 30-day free trial.

 ADOdb Database Abstraction Library for PHP (and Python) for MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Firebird, Interbase, LDAP, Access, VFP, DB2 and many other databases


ADOdb for Python

adodb.py

mxODBC - Python ODBC Database Interface

mxODBC manual



Connecting to ODBC Databases from Python with mxODBC

mxODBC Configuration Guide

Shared via AddThis




Reblog this post [with Zemanta]

No comments: