[Zope-DB] Problems with ODBC DB Adaptor

Thu, 7 Nov 2002 13:15:15 +0100

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C28657.54176010
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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?

Thanks in advance.

Yours sincerely

Stephan Smola
Information and Process Management
Information Technology

ThyssenKrupp Gerlach GmbH, Neue Industriestra=DFe, 66424 Homburg
Phone:	0 (49) 6841 107 139
Telefax.:	0 (49) 6841 107 525
e-mail:	mailto:Stephan.Smola@tka-ger.thyssenkrupp.com

Disclaimer:

Wie Sie wissen, k=F6nnen =FCber das Internet versandte
E-Mails unter fremdem Namen erstellt oder der Inhalt
ver=E4ndert werden. Aus diesem Grund sind unsere als
E-Mail verschickten Nachrichten grunds=E4tzlich keine
rechtsverbindlichen Erkl=E4rungen. Der Inhalt dieser
E-Mail samt Anlagen ist vertraulich und u. U.
rechtlich gesch=FCtzt. Der Inhalt ist ausschlie=DFlich
an einen bestimmten Empf=E4nger gerichtet.
Eine Weitergabe, die Herstellung von Kopien oder der
sonstige Gebrauch durch Nichtadressaten ist nicht
erlaubt. Ich bitte daher jeden anderen Empf=E4nger,
der diese E-Mail versehentlich erh=E4lt, mich umgehend
zu informieren und die Nachricht zu l=F6schen.

As you are aware, messages sent by e-mail can be
manipulated by third parties. For this reason our
e-mail messages are generally not legally binding.
This electronic message (including any attachments)
contains confidential information and may be
privileged or otherwise protected from disclosure.
The information is intended to be for the use of
the intended addressee only. Please be aware that
any disclosure, copy, distribution or use of the
contents of this message is prohibited. If you have
received this e-mail in error please notify me
immediately by reply e-mail and delete this message
and any attachments from your system. Thank you for
your cooperation.

------_=_NextPart_001_01C28657.54176010
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>Problems with ODBC DB Adaptor</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2 FACE=3D"Arial">Hi!</FONT>
</P>

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.

<P><FONT SIZE=3D2 FACE=3D"Arial">Are there any known problems with =
either ODBC or the ZODBCDA under heavy load or can there be something =
else?</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks in advance.</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Yours sincerely<B></B></FONT>
</P>

<P><B><FONT SIZE=3D2 FACE=3D"Arial">Stephan Smola</FONT></B>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Information and Process =
Management</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Information Technology</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">ThyssenKrupp Gerlach GmbH, Neue =
Industriestra=DFe, 66424 Homburg</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Phone:&nbsp; 0 (49) 6841 107 =
139</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">Telefax.:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 (49) =
6841 107 525</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">e-mail: <A =
HREF=3D"mailto:Stephan.Smola@tka-ger.thyssenkrupp.com">mailto:Stephan.Sm=
ola@tka-ger.thyssenkrupp.com</A></FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Disclaimer:</FONT>
</P>

Wie Sie wissen, k=F6nnen =FCber das =
Internet versandte
 E-Mails unter fremdem Namen =
erstellt oder der Inhalt
 ver=E4ndert werden. Aus diesem =
Grund sind unsere als
 E-Mail verschickten Nachrichten =
grunds=E4tzlich keine
 rechtsverbindlichen Erkl=E4rungen. =
Der Inhalt dieser
 E-Mail samt Anlagen ist =
vertraulich und u. U.
 rechtlich gesch=FCtzt. Der Inhalt =
ist ausschlie=DFlich
 an einen bestimmten Empf=E4nger =
gerichtet.
 Eine Weitergabe, die Herstellung =
von Kopien oder der
 sonstige Gebrauch durch =
Nichtadressaten ist nicht
 erlaubt. Ich bitte daher jeden =
anderen Empf=E4nger,
 der diese E-Mail versehentlich =
erh=E4lt, mich umgehend
 zu informieren und die Nachricht =
zu l=F6schen.

As you are aware, messages sent by =
e-mail can be
 manipulated by third parties. For =
this reason our
 e-mail messages are generally not =
legally binding.
 This electronic message (including =
any attachments)
 contains confidential information =
and may be
 privileged or otherwise protected =
from disclosure.
 The information is intended to be =
for the use of
 the intended addressee only. =
Please be aware that
 any disclosure, copy, distribution =
or use of the
 contents of this message is =
prohibited. If you have
 received this e-mail in error =
please notify me
 immediately by reply e-mail and =
delete this message
 and any attachments from your =
system. Thank you for
 your cooperation.

</BODY>
</HTML>
------_=_NextPart_001_01C28657.54176010--