[Zope-DB] Problems with Stored Procedures or Egenix mxODBXZope DA on Plone 3

[Banks, Justin C.]

Hi,

Has any one had any problems using stored procedures with egenix's
mxODBCZope DA? We started testing yesterday, and while regular ZSQL
methods don't present any problems, calls to stored procedures return
the following error:

Exception Type    OperationalError
Exception Value    ('HY000', 2014, "[MySQL][ODBC 3.51 Driver]Commands
out of sync; you can't run this command now", 1199)
Traceback (innermost last):

Module ZPublisher.Publish, line 125, in publish
Module Zope2.App.startup, line 238, in commit
Module transaction._manager, line 96, in commit
Module transaction._transaction, line 395, in commit
Module transaction._transaction, line 503, in _commitResources
Module transaction._transaction, line 625, in tpc_finish
Module Shared.DC.ZRDB.TM, line 60, in tpc_finish
Module Products.mxODBCZopeDA.ZopeDA, line 1126, in _finish
Module Products.mxODBCZopeDA.ZopeDA, line 999, in errorhandler
OperationalError: ('HY000', 2014, "[MySQL][ODBC 3.51 Driver]Commands out
of sync; you can't run this command now", 1199)

The configuration is:

Plone 3.0 beta3
Windows 32
MySQL 5.1.18
MySQL DB adaptor 3.51
Egenix mxODBCZopeDA 1.0.10 


Haven't had any problems with the same set up on Plone 2.5.2 


Any help would be greatly appreciated.

Justin



 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-db/attachments/20070517/1050f57c/attachment.htm