<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><pre><a rel="nofollow" href="http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-news-3-51-18.html">http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-news-3-51-18.html</a>
MySQL Connector/ODBC now supports batched statements. In order to enable
cached statement support you must switch enable the batched
statement option (<code class="literal">FLAG_MULTI_STATEMENTS</code>,
67108864, or <span class="guilabel">Allow multiple statements</span>
within a GUI configuration). Be aware that batched statements
create an increased chance of SQL injection attacks and you must
ensure that your application protects against this scenario.
(<a href="http://bugs.mysql.com/7445" target="_top">Bug#7445</a>)
</pre><div><br></div><div><br></div><div><div>On Nov 26, 2009, at 2:22 PM, Frank @ Impact wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="stockticker">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
span.EmailStyle17
{mso-style-type:personal-compose;
mso-style-noshow:yes;
mso-ansi-font-size:12.0pt;
mso-bidi-font-size:12.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none;
text-underline:none;
text-decoration:none;
text-line-through:none;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
<div lang="EN-US" link="blue" vlink="purple" style="tab-interval:.5in">
<div class="Section1"><p class="MsoNormal"><span class="GramE"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial">“GREAT SCOTT!!!</span></font></span><font face="Arial"><span style="font-family:Arial"> Cannot execute batched statements!<o:p></o:p></span></font></p><p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;
font-family:Arial">If you are using <span class="SpellE">mysql</span>, make sure
you are using MYODBC 3.51.18 or higher and enable </span></font><st1:stockticker><font face="Arial"><span style="font-family:Arial">FLAG</span></font></st1:stockticker><font face="Arial"><span style="font-family:Arial">_MULTI_STATEMENTS”<o:p></o:p></span></font></p><p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;
font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;
font-family:Arial">I realize a bit off of list topic…<o:p></o:p></span></font></p><p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;
font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;
font-family:Arial">But I do have <span class="SpellE">mysql</span> 3.51.18 and
higher but for the life of <span class="GramE">me ,</span> I cannot seem to get
the DSN <span class="SpellE">config</span> setup so that the <span class="SpellE">odbc</span>
connector seems to tell FS that it can do multi statements.<o:p></o:p></span></font></p><p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;
font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;
font-family:Arial">Anyone have any insight on how and where to set this flag?<o:p></o:p></span></font></p><p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.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>
</div>
_______________________________________________<br>FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>http://www.freeswitch.org<br></o:smarttagtype></blockquote></div><br></body></html>