[Zope-DB] Problems with ODBC DB Adaptor

M.-A. Lemburg mal@lemburg.com
Thu, 07 Nov 2002 13:20:47 +0100

Smola, Stephan wrote:
> Hi!
> We are using Zope 2.5.0 with ZODBCDA 3.0.3 on Win2K Server. Via the 
> ZODBCDA we connect to several Acces DBs to retrieve and save data.
> For some time now we seem to have problems with the odbc db connection 
> under heavy load, i.e. many (maybe concurrent) requests to a odbc data 
> source are done in a short time.
> At least the connections close and we get an INVALID CONNECTION STRING 
> when trying to open the connection again. Sometimes the whole Zope 
> Service seems to freeze. Both issues can only be solved by restarting 
> the Zope service.
> Are there any known problems with either ODBC or the ZODBCDA under heavy 
> load or can there be something else?

You may want to try the mxODBC Zope DA which we currently have
in beta. It is designed to work well under heavy load and
support parallel execution of Z SQL methods.

PS: One of your colleagues has already signed up as beta tester.

Marc-Andre Lemburg
CEO eGenix.com Software GmbH
eGenix.com -- Makers of the Python mx Extensions: mxDateTime,mxODBC,...
Python Consulting:                               http://www.egenix.com/
Python Software:                    http://www.egenix.com/files/python/