Office's Access XP ODBC DBI from PythonWin
sholden at holdenweb.com
Thu Jun 14 04:23:50 CEST 2001
"Dirk Leas" <dirkLeas at mac.com> wrote in message
news:mailman.992468723.17992.python-list at python.org...
> Anybody luck working w/ DbiDate from query result? Check out the
> >>> import dbi, odbc
> >>> db = odbc.odbc('testAccess')
> >>> cursor = db.cursor()
> >>> cursor.execute('select * from person')
> >>> rows = cursor.fetchall()
> >>> rows
> [(1, 'Joe Smith', <DbiDate object at 010ED560>), (2, 'Mary Smith',
> <DbiDate object at 010CEBC0>)]
> >>> str(rows)
> I'm running the latest of AS's Python with the Win32 extensions against
> Office XP Access.
Has the Win32 odbc module been updated at all since 2.0? I have a feeling
you might find it less than satisfactory for extended use - I've certainly
had problems myself.
Unfortunately the dbi.dbiDate object has a null __doc__,but I notice the
dbi.py module requires mx.DateTime. Had you considered using mx.ODBC instead
of ODBC? If you don't plan commercial use it is free, and I can certainly
recommend it for ease of use.
More information about the Python-list