<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:Times;
        panose-1:2 2 6 3 5 4 5 2 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-compose;
        font-family:Arial;
        color:windowtext;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hi,<br>
<br>
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:<br>
<br>
</span></font><b><font size=2 color="#333333"><span style='font-size:10.0pt;
color:#333333;font-weight:bold'>Exception Type </span></font></b><font
face=Times><span style='font-family:Times'>OperationalError<br>
</span></font><b><font size=2 color="#333333"><span style='font-size:10.0pt;
color:#333333;font-weight:bold'>Exception Value </span></font></b><font
face=Times><span style='font-family:Times'>('HY000', 2014, "[MySQL][ODBC
3.51 Driver]Commands out of sync; you can't run this command now", 1199)<br>
</span></font><font size=2 color="#333333"><span style='font-size:10.0pt;
color:#333333'>Traceback (innermost last):<br>
</span></font><font face=Times><span style='font-family:Times'><br>
Module ZPublisher.Publish, line 125, in publish<br>
Module Zope2.App.startup, line 238, in commit<br>
Module transaction._manager, line 96, in commit<br>
Module transaction._transaction, line 395, in commit<br>
Module transaction._transaction, line 503, in _commitResources<br>
Module transaction._transaction, line 625, in tpc_finish<br>
Module Shared.DC.ZRDB.TM, line 60, in tpc_finish<br>
Module Products.mxODBCZopeDA.ZopeDA, line 1126, in _finish<br>
Module Products.mxODBCZopeDA.ZopeDA, line 999, in errorhandler<br>
OperationalError: ('HY000', 2014, "[MySQL][ODBC 3.51 Driver]Commands out
of sync; you can't run this command now", 1199)<br>
<br>
The configuration is:<br>
<br>
Plone 3.0 beta3<br>
Windows 32<br>
MySQL 5.1.18<br>
MySQL DB adaptor 3.51<br>
Egenix mxODBCZopeDA 1.0.10 <br>
<br>
<br>
Haven’t had any problems with the same set up on Plone 2.5.2 <br>
<br>
<br>
Any help would be greatly appreciated.<br>
<br>
Justin<br>
<br>
</span></font><font size=2 face=Arial><span style='font-size:10.0pt;font-family:
Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>