TR: [egenix-users] SQL Server: Experimental Solution

[Sébastien Walgraffe]

Hello

We can t use the solution proposed by nwingfield at che-llp.com. Because we
call ZSQL from a product and we don t have at this place the REQUEST.
With the modifications that you planned in Vesrion 1.0.7, do you think that
it will work if we call ZSQL without REQUEST parameter ?

Thanks

Sebastien Walgraffe

-----Message d'origine-----
De : egenix-users-bounces at lists.egenix.com
[mailto:egenix-users-bounces at lists.egenix.com]De la part de M.-A. Lemburg
Envoyé : jeudi 23 octobre 2003 13:12
À : nwingfield at che-llp.com
Cc : egenix-users at lists.egenix.com
Objet : Re: [egenix-users] SQL Server: Experimental Solution

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.

If this does solve your problems, we'll add a connection option to the
Zope DA which will let you switch on/off this behaviour (grouping
connections per request) for version 1.0.7.

--
Marc-Andre Lemburg
eGenix.com

Professional Python Software directly from the Source  (#1, Oct 23 2003)
 >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::


_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
http://lists.egenix.com/mailman/listinfo/egenix-users