[Zope] Invalid Cursor state error

[Zopista]

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...

--
  Andy McKay

----- Original Message -----
From: "matt standish" <mps_@hotmail.com>
To: <zope@zope.org>
Sent: Tuesday, April 03, 2001 2:16 PM
Subject: [Zope] Invalid Cursor state error


> Hello,
> I am having a problem with my Zope/ Mysql system and was hoping that some
> kind soul in Zope land may be able to help me.
> I am running Zope 2.3.0 (Binary release, python 1.5.2 win 32-x86)
> MySQL using ZODBC to communicate with Zope.
> I am using a Win 98 SE box for development and NT 4 server when it is
> complete.  The error I am receiving is:
>
> Error Type: sql.error
> Error Value: ('24000',0,'[Microsoft][ODBC Driver Manager] Invalid cursor
> state')
>
> I receive this error after 3 queries to the database.  The type of queries
> makes no difference.  I am not using cursors in my database.  The ODBC
trace
> logs give the following errors:
>
> <...snip...>
> z2 fffc4b8b-fffc2717 ENTER SQLExecDirect
> HSTMT 015E26F0
> UCHAR * 0x012EEE74 [ 22] "select * from u_server"
> SDWORD 22
>
> z2 fffc4b8b-fffc2717 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
> HSTMT 015E26F0
> UCHAR * 0x012EEE74 [ 22] "select * from u_server"
> SDWORD 22
> DIAG [24000] [Microsoft][ODBC Driver Manager] Invalid cursor state (0)
>
> z2 fffc4b8b-fffc2717 ENTER SQLErrorW
> HENV 016DFC40
> HDBC 00000000
> HSTMT 015E26F0
> WCHAR * 0x01E5F374 (NYI)
> SDWORD * 0x01E5F3B0
> WCHAR * 0x01E5EF74
> SWORD 511
> SWORD * 0x01E5F3AE
>
> z2 fffc4b8b-fffc2717 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
> HENV 016DFC40
> HDBC 00000000
> HSTMT 015E26F0
> WCHAR * 0x01E5F374 (NYI)
> SDWORD * 0x01E5F3B0 (0)
> WCHAR * 0x01E5EF74 [ 53] "[Microsoft][ODBC Driver Ma"
> SWORD 511
> SWORD * 0x01E5F3AE (53)
>
> <...snip...>
>
>
> Any suggestions?  I have tried to use the MySQL database method but could
> not install it correctly.
> Thanks
> -Matt
>
> _______________________________________________
> 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 )
>