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,163 of 9,834    |
|    Tom Krieg <"Please use the website to Gene De Guzman    |
|    Re: qLocate Fails on Firebird DB after 1    |
|    21 Apr 08 15:14:09    |
      This sounds like the server is disconnecting from the Paradox session.       Have you updated your Firebird software?              Now, I trust you're not going to say that you're using the native BDE       Interbase SQL Link to access a Firebird database using a TCursor.       Because if you are then you are boldly walking into the cavern of a       vicious, fiery dragon without armour or a sword and not even your faith       in all things good will save you.              I can't stress enough that direct access to SQL server tables in Paradox       will cause grief. Tcursors are particularly prone to causing problems.       If you access a Firebird database using the native Interbase link well,       Firebird's had numerous releases and updates since the Interbase 6       code-base turned into Firebird 0.0.1 so something MUST have changed.              You will eventually confront the reasons why everyone says not to do it.              Gene De Guzman wrote:       > 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.       >       --       Tom Krieg              ---------------       http://www.krieg.com.au       Please use the contact page to contact me via email              --- 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