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
No comments:
Post a Comment