| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Oracle 7 ODBC Driver - Repeated login and Timeout
Hi,
I hope this is not off topic here.
We have a report tool implemented with MS Access 2000. The data we use is on an Oracle Server running Oracle 7. We have the ODBC Driver Version 2.05.03.01, which is the newest one. We are having two problems we don't know how to solve:
When we are doing a select that queries three different tables, we get the login screen three times and have to type in the password three times. We would like the login window to appear just once. I'm not sure if this is an Access problem, or if there is some setting with the ODBC driver that will tell it to use just one connection for everything.
Some of those queries run for a long time, and it seems to us we run into some timeout and are logged out from the database. If we restart the query we have to type all passwords again. We would like to have to type in the password just the very first time we make a connection to the database, and then never again on that session. Is there any way to set up a timeout for the ODBC connection ?
Thanks in advance,
--
Heber Ferraz-Leite (h.ferraz-leite_at_fsc.at)
 |
 |