Mailing List Archive

Sudesh Soni wrote at 2006-6-21 18:13 +0530:
>I get the below error :
>
>
>OperationalError on <Products.mxODBCZopeDA.ZopeDA.DatabaseConnection "DSN=Zope" thread 2476/2476 at 0x27150c4>: ('08S01', 11, '[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.', 6108)

Do you have a firewall between Zope and your SQL server?

Firewalls occationally drop connections in a way that
the endpoints get not informed. Lateron, problems can occur
like the one you are currently facing.


--
Dieter
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Dieter,
Thanks for your reply.
Yes , i have SonicWall VPN Client version 2.2.2.210 running on our SQL
server. If this is the reason then, do i have to make some changes in the
settings/properties in Sonic wall ?
Or any other way to resolve this problem?

Sudesh

----- Original Message -----
From: "Dieter Maurer" <dieter@handshake.de>
To: "Sudesh Soni" <sudesh.soni@ebusinessware.com>
Cc: <zope-db@zope.org>
Sent: Thursday, June 22, 2006 3:17 AM
Subject: Re: [Zope-DB] Operation Error : Using Zope2.6.1 and mxODBCZopeDA


> Sudesh Soni wrote at 2006-6-21 18:13 +0530:
> >I get the below error :
> >
> >
> >OperationalError on <Products.mxODBCZopeDA.ZopeDA.DatabaseConnection
"DSN=Zope" thread 2476/2476 at 0x27150c4>: ('08S01', 11, '[Microsoft][ODBC
SQL Server Driver][DBNETLIB]General network error. Check your network
documentation.', 6108)
>
> Do you have a firewall between Zope and your SQL server?
>
> Firewalls occationally drop connections in a way that
> the endpoints get not informed. Lateron, problems can occur
> like the one you are currently facing.
>
>
> --
> Dieter

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

On 2006-06-22 at 07:09:36 [+0200], Sudesh Soni
<sudesh.soni@ebusinessware.com> wrote:
> Dieter,
> Thanks for your reply.
> Yes , i have SonicWall VPN Client version 2.2.2.210 running on our SQL
> server. If this is the reason then, do i have to make some changes in the
> settings/properties in Sonic wall ?
> Or any other way to resolve this problem?

Sudesh,

as the problem is with your network and/or firewall you need to check those
components. Check the documentation and contact the supplier. We often get
requests of this kind but we cannot help as the problem has nothing to do
with Zope or the mxODBC driver.

Charlie
--
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
________________________________________________________________________
2005-10-17: Released mxODBC.Zope.DA 1.0.9 http://zope.egenix.com/

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Sudesh Soni wrote at 2006-6-22 10:39 +0530:
> ...
>Yes , i have SonicWall VPN Client version 2.2.2.210 running on our SQL
>server. If this is the reason then, do i have to make some changes in the
>settings/properties in Sonic wall ?

Usually, firewalls have an option to configure how long the connection
inactivity timeout should be. Check your firewall documentation...

>Or any other way to resolve this problem?

We work around the problem by catching the "OperationalError",
close the connection, reopen it and than raise
an exception derived from "ZODB.POSException.ConflictError".
The last step causes ZPublisher to repeat the request automatically.



--
Dieter
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db