[Zope] ODBC errors

[Philipp Auersperg]

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 )