Re: Oracle 7 ODBC Driver - Repeated login and Timeout

Hi,

we have almost the same problem.
We're running a call logging program called HEAT by Bendata. This program runs with an Oracle database perfectly. The reporttool provided with this program however can only work with an Access database.
We connected an Access 97 by ODBC to the Oracle database. We then connected the Access database to the reporttool.
When we start the reporttool it asks for a login. The dialogbox says 'Logon to Oracle'. The reporttool starts and when we run a query the same dialogbox pops up again and we have to logon again. This is the case for every query we run.

My question is:
Does the same course of action suggested in the answer apply for us ? And if not, could anyone propose a course of action we can take ?

Many thanks in advance...

Guido Scheuerman

Heber Ferraz-Leite <h.ferraz-leite_at_fsc.at> schreef in berichtnieuws 4aM34.34$ma5.330_at_news.chello.at...
> 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 Mon Dec 13 1999 - 06:39:55 CST