Re: Oracle 7 ODBC Driver - Repeated login and Timeout

We had the same problem & changed to microsoft ODBC driver for Oracle. It runs just fine now !!!

Philippe Backouche (philippe_at_arpege.imaginet.fr)

Heber Ferraz-Leite a écrit :

> 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)
> --------------------
> Ferraz-Leite Software Engineering & Consulting KEG
> http://www.fsc.at/
Received on Thu Dec 09 1999 - 15:31:52 CST