[DB-SIG] Acessing DBISAM files via mxODBC
Sun, 11 Feb 2001 08:12:04 -0600
I have data in DBISAM files which I'd like to access via Python.
I have installed an ODBC driver for DBISAM;
found at http://www.elevatesoft.com/usercode.htm
and mxODBC; http://www.lemburg.com/files/python/mxODBC.html
this is my program;
import ODBC.Windows as odbc
con =3D odbc.Connect('photos', user=3D'', password=3D'')
cur =3D con.cursor()
--it seems OK at this point;
<mxODBC Cursor object at 016F9570>
I am unable to do anything with the cursor, I keep getting the
parameter mismatch message.
>>> cur.execute('select * from datafile')
Traceback (innermost last):
File "<interactive input>", line 1, in ?
InterfaceError: mismatch in number of parameters; expected 63,=
I don't understand this error message.
Is the driver just incompatable with the mxODBC module?