Re: qLocate Fails on Firebird DB after 1 hour of Inactivity

Dear Simon,

Having a timer running on the  client that does a single SELECT from the 
database every 15 minutes solved the problem !!!!!

Thanks.

Gene


"SimonW" <Simon@[EMAIL PROTECTED]
> wrote in message 
news:480c43bd$1@[EMAIL PROTECTED]
> Gene De Guzman wrote:
>  > Any ideas?
>>
> Have you checked out the DummyPacketInterval parameter in your 
> firebird.conf file ?  I have experienced flaky behaviour with this
setting 
> in both FB and IB.  You can test to see whether the connection is being 
> dropped at the client or server end by connecting to FB using a specific

> user name, waiting long enough for the problem to occur and then looking

> on the server database to see whether FB still sees the user as an 
> attachment.
>
> Also do you have any routers or other network baggage between the client

> and workstation ?  I have had issues where routers appear to block the 
> keepalive packet between FB and client.
>
> One solution that has worked for me is to have a timer running on the 
> client that does a single SELECT from the database every 10 minutes or
so. 
> This keeps the connection alive.
>
> Hope this helps
>
> SimonW