home bbs files messages ]

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,164 of 9,834   
   SimonW to Gene De Guzman   
   Re: qLocate Fails on Firebird DB after 1   
   21 Apr 08 08:32:41   
   
   From: Simon@nospam.co.uk   
      
   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