[DB-SIG] newbie question regarding mxODBC
Mon, 08 Oct 2001 17:54:50 +0200
Ana Must wrote:
> using mxODBC, I can successfully connect to an Access
> database and execute queries. I would like to get the
> list of the existing tables in the database, but I
> don't know how.
> When I use the Cursor method tables(), I just get
> the value -1.
.tables() generates a result set which you must fetch from
the database using e.g. .fetchall().
The layout of the result set is documented in your ODBC driver
manual but should usually be a superset of what is defined in the
ODBC standard documentation (see the mxODBC docs for a link to the
Microsoft pages on this).
CEO eGenix.com Software GmbH
Consulting & Company: http://www.egenix.com/
Python Software: http://www.lemburg.com/python/