Re: Oracle 7 ODBC Driver - Repeated login and Timeout

Hi

Using Access97 and Oracle8 driver when you create an access database link you get an option on the dialog box to save the oracle password. This works for me. NB I have found no way to do this AFTERV first linking the table so you may need to delete your linked table and recreate it.

Niall
"Guido Scheuerman" <guido_at_x-sitement.nl> wrote in message news:832ovg$chg$1_at_news.worldonline.nl...
> 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 - 09:10:54 CST