I have a couple of ODBC query's running from an access DB to an Oracle DB. All is good and fine. However sometimes i have trouble connecting to the Oracle DB.
2 things may happen....:
1) I get the common "ODBC error connection failed"
The SQL is 100% OK, except connection failed or something, i need to restart the DB to clear the memory (and avoid the timeout wait time) to retry.
2) The Access DB Crashes. It doesnt give an error or anything, it just "disappears", again restart and retry.
These 2 can repeat and intermittently show up, Or on try 1 have problem 2, try 2 problem 1 and Vice versa...
Try try try untill it works. Its a pain, is there anybody out there who has experience simmular problems in the past (WinNT, Access 97 - SR2)
NT & A97, yes i know => But hey, thats what my employer uses. But we are planning to upgrade "pretty soon"
Alternative for ODBC? What how when why what? I dont know it, could you elaborate?
Edit: Login - Timeout? hmz, i checked to ODBC time out, thats set to 60 secs (usual return time is less than 1 sec) Didnt know there was a Login timeout as well. Where can i find/set it?
Also if the Login timeout expires shouldnt there be a "normal" error message instead of a crashlike situation?