Re: Ora-01017 when using Access2002 as Front instead of Access2000

On Apr 25, 2:41 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> mainframetech schreef:> We are having a problem with Access 2002 as opposed to Access 2000
> > when fronting for an Oracle database (9.1).
> > A multi-file query was set up under Access2000 and tested good.
> > Access is
> > connected through a link to an Oracle 9.1 database. The database
> > (mdb) was installed in
> > remote client machines working with Access2000 and it worked fine.
> > When the query was put on an Access2002 machine, it came up with
> > "ORA-01017 invalid logon/password", and fails. The failing machine
> > passes other queries and operations with the same Oracle database
> > without problem.
>
> > Any help is appreciated.
>
> Type the correct username and password. What else?
> Seems a pretty obvious error.
>
> Perhaps this info is embedded in e.g. an ODBC connector; alter
> that then.
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

Thanks Frank. However we passed the level of checking for correct ID/ password long ago. The ODBC connector is OK also, since they have used it for other queries on the same machine. I wouldn't have posted here unless we had already checked out the more obvious stuff. I guess we ned an expert to answer this one.

Chris Received on Thu Apr 26 2007 - 12:10:36 CDT