I have worked with ODBC and Zope under Win2k and had no such problems with MSSQL,Oracle and Access. Since you work with mysql the problem seems to happen in conjunction with the mysql ODBC AND Zope, I don't have experiences with MySQL ODBc, but: If you work with mysql & Zope I would anyhow recommend Zope's native mysql adapter since it is full-threaded and ZODBCDA is not. *********** REPLY SEPARATOR *********** On 06.01.2001 at 10:41 Doug Brewer wrote:
Hello
I'm relatively new to Zope, and have been working on getting mySql connected via ZODBC on Win2k. The connection is working, however, I have one column which repeatedly throws an error when I try to access data. The column contains text with many "\n" to retain formatting for email messages (it's an archive).
The error seems to be from the ODBC driver:
Error, sql.error: ('24000', 0, '[Microsoft][ODBC Driver Manager] Invalid cursor state')
however I can successfully access values from this column directly from the mysql console AND through the exact same datasource used by zope but from other apps (I used Excel as a test, and successfully returned data). IOW, only Zope produces this error.
Any thoughts or pointers would be greatly appreciated.
Doug Brewer
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )