[Zope-DB] sql query works in database connector but not in ZSQL
dieter at handshake.de
Wed Jan 17 17:26:08 EST 2007
robert rottermann wrote at 2007-1-17 15:42 +0100:
>when I execute this directly in the test "window" of the database
>connection, it works fine.
>when i execute the same line in the test window of a ZSQL Method
>then I get an error:
>Error, Products.mxODBCZopeDA.ZopeDA.ReplayTransaction: OperationalError
>on : ('HYT00', 2014, "[unixODBC][MySQL][ODBC 3.51
>Driver][mysqld-5.0.26]Commands out of sync; you can't run this command
>now", 6113) SQL used:
Apparently, this error message comes from the "mysql" server.
The most natural way to find out about this error is therefore,
to consult the MySQL documentation to learn under what circumstances
this error is raised.
More information about the Zope-DB