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 - [EMAIL PROTECTED]
>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 )
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
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 )
