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,161 of 9,834   
   Gene De Guzman to All   
   qLocate Fails on Firebird DB after 1 hou   
   21 Apr 08 06:47:24   
   
   From: winapps@i-manila.com.ph   
      
   Hi All,   
      
   I have a timekeeping system that is connected thru a mapped drive to a   
   firebird DB.   
   Everything works fine when a lot of people are coming IN & OUT.   
   When the workstation is idle IDLE for about 1 hour, my IF NOT   
   tc.qlocate(empID) would fail for all subsequent users and the user would   
   need to exit my application and go back in (not logoff the PC but only exit   
   pdox) and everything works fine again.   
      
   All power schemes for the PC and NICs are set to never.  We even added a   
   registry entry in the server to allow unlimited autodisconnect timeout but   
   this has not solved te problem.  Before a tc.qlocate(empID) is performed, we   
   have IF NOT tc.Open(":DATA:EMPFILE")  ... and this does not raise an error.   
   I have a timer running on the form that displays the date and time.  We have   
   tried to duplicate the problem in another small server and the problem does   
   not happen.   
      
   Any ideas?   
      
   TIA.   
      
   Gene   
      
   --- 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