[egenix-users] SQL Server: Experimental Solution

[nwingfield at che-llp.com]

Peter Sabaini <sabaini at telbiomed.at> wrote on 10/23/2003 09:03:50 AM:

> How does this play along with the Zope transaction machinery?

I'm not sure of the answer to this question.  Does anyone on the list know?
I'm a bit worried about this myself.

> Also, since we have tons of ZSQL Methods around, this is a bit
> impractical for us :-(

You don't need to tell me about lots of Z SQL methods!  I had to convert
153 of them to Python scripts, each calling my executeSQL external method.
If you would like more details on how I achieved this with minimal effort,
I will be glad to explain more.

Nathaniel

>
> nwingfield at che-llp.com wrote:
> > We have been experiencing many problems with mxODBC and SQL Server,
similar
> > to those expressed by others list members (Sébastien Walgraffe, Peter
> > Sabaini).  The most common error is this:
> > 'HY000', 0, '[Microsoft][ODBC SQL Server Driver]Connection is busy with
> > results for another hstmt', 5911
> > By eliminating Z SQL methods, we seem to have remedied this error,
though
> > only time will tell.  We have replaced Z SQL methods with the External
> > Method that I am including below.  Another problem that we experienced
was
> > that when the connection pool was set greater than one, pages executing
> > multiple SQL statements could lock up.  This is because each SQL method
was
> > potentially executed on a different connection.  Rather than limit
> > ourselves to a connection pool of one, we incorporated some logic into
the
> > aforementioned method to maintain one connection per request.  If the
> > locking isn't a problem for you, you can strip the extra logic out of
this
> > method.
> >
> > Let me know if this helps.
> >
>
> --
> =========================================================================
>    Peter Sabaini
>    ARC Seibersdorf research GmbH, Biosignal Processing and Telemedicine
>    Grottenhofstrasse 3, A-8053 Graz
>    T: +43 (0)316 265 158, F: +43 (0)316 265 155; E: sabaini at telbiomed.at
>    H: http://telbiomed.at, IM: chrome___ at jabber.at
> -----------------------------
> Meet us at the MEDICA 2003 in Duesseldorf
> 19. - 22. Nov. Hall 14 Stand D15
>
>
>
>
>