BorlandTalk.com

Nico Callewaert · Guest

Hi,

I've posted a message about this problem a few weeks ago. I
followed the advice but the problems remains : The connection
to the database server is gone intermittently. And the ISAPI
is unable to reconnect (I provided a procedure to reconnect).
The IIS has to be stopped and restarted before the connection
works again.
I think the problem is the Watchguard Firewall where the
webserver is connected on the DMZ port. I think it's useless
to look to change the ISAPI, because the whole thing is unable
to reconnect, because of the underlaying hardware. The problem
is : how can I solve this ? Working with a db on the webserver
itself ?
But then I will have the same problem to synchronize, isn't
it ? I have to come up with a solution, but I don't know
how.....

Any help is very appreciated,
Thanks in advance,

Nico Callewaert

Shiv Kumar · Guest

Nico,

In the past, I've solved this kind of issue one way...

I built a windows Service (NT service application) application that would
connect to the database server in the DMZ and disconnects every 10 minutes
or so. The duration depends on your firewall settings. This keeps the ports
open so the firewall sees some activity and doesn't timeout.
--
Shiv R. Kumar
The Delphi Apostle
http://www.matlus.com

Nico Callewaert · Guest

Hi Shiv,

First of all, thanks for the reply. You mentioned that
already in your previous mail a few weeks ago. So I've
written such a application, and set the timer to every 10
minutes. It works fine for a day or so and then also that
application gives the same errors and once the connection is
broken it can't be restored anymore. Maybe the 10 minutes
setting is a bit long, maybe I can try to decrease that
value. Is that the way to do it : connecting the webserver
to the DMZ port ? Or are we asking for trouble that way ?

Thanks in advance,
Nico

"Shiv Kumar" <shivk (AT) erols (DOT) com> wrote:

Shiv Kumar · Guest

You should reduce the time then. Make it every minute. I'm assuming your
"service" app is running on the Web Server machine. This service should
connect to your database on the machine in the DMZ. This should keep the
port open and prevent and disconnection.

Of course, the ideal solution is for your network administrators to change
their setup :)

--
Shiv R. Kumar
The Delphi Apostle
http://www.matlus.com