[Zope] 'System resources exceeded' error with ZODBCDA and Access

Kees de Brabander cj.de.brabander@hccnet.nl
Thu, 7 Mar 2002 22:53:56 +0100


I definitely remember that the culprit for your problem is Access. You'll
have to look for another database.
I realize this sounds not very helpfull, sorry.
cb
----- Original Message -----
From: "Igor Leturia" <IGOR@emun.com>
To: <zope@zope.org>
Sent: Thursday, March 07, 2002 3:55 PM
Subject: [Zope] 'System resources exceeded' error with ZODBCDA and Access


  Hi all!

  I have Zope 2.3.2 installed on a Windows 2000 Server. I have an Access
databases and I make queries on it using ZODBCDA. It works fine, but
after some time running it gives an error which in English would be
(more or less) 'Microsoft ODBC Error. System resources exceeded'. The
only way to get it running again is restarting Zope?

  The database is not very big (about 8000 records). Is it a problem of
ZODBCDA, or is it Microsoft's Access ODBC driver's? Do I have to change
some parameter (cache, etc.) in any of them?

  Any help would be appreciated. Thanks in advance,

Igor Leturia

_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )