Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Ora-01017 when using Access2002 as Front instead of Access2000

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

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 25 Apr 2007 20:41:43 +0200
Message-ID: <f0o77p$nit$2@news5.zwoll1.ov.home.nl>


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...
Received on Wed Apr 25 2007 - 13:41:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US