[DB-SIG] Acessing DBISAM files via mxODBC

Kent Tenney kent@springfed.com
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;
>>> cur
<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,=
 found none 

I don't understand this error message.

Is the driver just incompatable with the mxODBC module?

Any suggestions?