Subject Re: Discouraged with the firebird
Author sdbeames
<peter_jacobi@g...> wrote:
> Hi Humberto,
>
> My guess on this issue, is that the W2K workstation
> completely drop the connection to the server, when no
> packets are exchanged. This can be changed by some
> obscure registry setting, I'm sure.
>
> OTOH, if I don't mix things up, the automatic sending
> of keep-alive packets have been dropped in FB for
> Win systems, as they resulted in even worse problems.
>
> So, if memory serves me right, the best work-around is
> to add some application layer keep-alive handling in
> your client-side app.
>
> Regards,
> Peter Jacobi

I can second that! All my network problems have gone since I started
making dummy queries at timed intervals to keep the connection valid.
I'm guessing our new network hardware drops inactive connections and
reassigns IPs after about 30 minutes or so.

HTH,
Steve