Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.paradox    |    To crash or not to crash, asks Borland    |    9,834 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 9,260 of 9,834    |
|    Gene De Guzman to SimonW    |
|    Re: qLocate Fails on Firebird DB after 1    |
|    17 Jun 08 05:44:08    |
   
   From: winapps@i-manila.com.ph   
      
   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" wrote in message   
   news:480c43bd$1@pnews.thedbcommunity.com...   
   > 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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca