[Zope] Invalid Cursor state error

[Thomas B. Passin]

Zopista said -

> This is a ODBC specific problem related to SQL. Ive looked into cursor and
> get more confused the more I learn. If you can try and simplify your
query.
> If all else fails try the perlDBI or mxODBC as alternatives...
>
 I suggest you find a way to verify that the odbc data source works (outside
zope).  One way is to get mxOdbc working in Python.  It may be that mySQL
has enough tools to do this, I don't know.

Alternatively, use ODBC to create some other kind of database.  If you have
an Access ODBC driver you can create an Access database.  Create a table,
then try to connect to it from zope using the ZODBC product.

Anyway, it's important to be able to verify the the ODBC data source works,
if you are going to keep using ODBC and are still having trouble.  I don't
have mySQL isntalled now, but I did last month and the ODBC driver worked
OK.

Cheers,

Tom P