[Zope-DB] win32 odbc DA constantly losing connection

M.-A. Lemburg mal@lemburg.com
Wed, 26 Feb 2003 10:04:06 +0100

T. Muddletin wrote:
> I've been having a very annoying time with zope's ODBC DA, on windows.
> After a half dozen or so queries it would lose its connection to a
> postgresql database (running on freebsd on the lan).

You may want to try the prerelease version of the mxODBC Zope DA.
If you're interested, I can send you an eval copy.

> When i'd try to re-"open" the database in zope i'd get "Invalid
> connection string: dsn" (where 'dsn' is the name of the odbc data
> source).
> Yet the data source is okay. Other apps maintain their connection. The
> only way i seem to get zope to reconnect though is to shut it down and
> restart it completely.
> In desperation searching for alternatives i finally got slightly old
> psycopg working using the binary found on zope.org at
> http://www.zope.org/Members/pvl/PsycopgWin32 and I was a (relatively)
> happy camper again... things seemed grand.
> And then suddenly this DA lost its connection also. Distressing!
> However, there was a difference... when i tried to re-open this
> connection i see the error: "psycopg.OperationalError FATAL: Sorry,
> too many clients already"
> AH!! So that's it! Now at least I know what seems to be the actual
> problem. I'm still not happy about the DA completely shutting down...
> what's it doing with all those other connections it is holding open?
> But at least now I can try to work with the problem and increase the
> connections available in postgresql or something.

Marc-Andre Lemburg

Professional Python Software directly from the Source  (#1, Feb 26 2003)
 >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
Python UK 2003, Oxford:                                     34 days left
EuroPython 2003, Charleroi, Belgium:                       118 days left