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
_______________________________________________ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db