<docbook><section><title>ConnectionIsBusyWithResultsForAnotherHSTMT</title><title>Connection is busy with results for another hstmt
</title>Connection is busy with results for another hstmt

<para>This error is generally resolved by enabling <emphasis>Multiple Active Statements Emulation</emphasis>, also known as <emphasis>MASE</emphasis>, in your data source configuration.
 This uses the OpenLink Cursor Library to emulate multiple statement execution, with a small performance penalty.</para><itemizedlist mark="bullet" spacing="compact"><listitem> GUI-based ODBC DSN Setup should have an obvious checkbox for this on all platforms, or you may manually add the following line to DSN definitions in $ODBCINI -- <programlisting>MultipleActiveStmtsEmul = Y
</programlisting></listitem>
<listitem> DSNless connect strings may use either of the following -- <programlisting>MASE = Y
MultipleActiveStmtsEmul = Y
</programlisting></listitem>
</itemizedlist><para> If connecting to <emphasis>Microsoft SQL Server 2005 or later,</emphasis> you may prefer to use its built-in <ulink url="ConfigureSQLMARS">Multiple Active Result Sets</ulink> feature, which does not carry the performance penalty of MASE.</para></section></docbook>