Re: [Microsoft][ODBC driver for Oracle][Oracle]ORA-01017: invalid username/password; logon denied
Date: 1 Oct 2001 07:21:10 -0700
Message-ID: <8219003a.0110010621.6e31918d_at_posting.google.com>
Const CONN_STRING = "driver={Microsoft ODBC for Oracle};DSN=oraconn; UID=secdes1;PWD=secdes1"
- This connection string does work: Const CONN_STRING = "driver={Microsoft ODBC for Oracle};DSN=oraconn; UID=system;PWD=manager"
NOTE: system/manager lets us see the oracle system tables. secdes1 was setup as an administrator user for our actual tables.
"Robert" <malikian_at_malikian.homechoice.co.uk> wrote in message news:<3bb7891c$1_at_news1.homechoice.co.uk>...
> Could you post the connection strings. I think you are missing something
> very simple.
> Robert
> "Steve" <scoobie_doo_at_e-mailanywhere.com> wrote in message
> news:8219003a.0109281217.7a243c6e_at_posting.google.com...
> > I would really appreciate if someone could explain to me this problem.
> > I'm new with Oracle and I'm trying to connect to Oracle v.8.1.5
> > (we'll call it DB#1)through an ODBC connection via an ASP page. It
> > works with trying to connect to a 7.3 (we'll call it DB#2)Oracle
> > database, and it will connect to the DB#1 using the "system/manager"
> > userid/password. When I try to connect to DB#1 using the other user
> > login "secdes1/secdes1", I get this issue. I have already tried
> > access by changing the password to something different and it doesn't
> > work. I'm using the Microsoft ODBC for Oracle driver in the dsn and
> > I've made sure that my ADO connection string is correct.
> >
> > I'm at my wits end and would really appreciate the info. My team has
> > been able to do the SQLPlus connections through our laptop to DB#1 and
> > there's no problem.
> >
> > ARRRRRRGGGHHHHH!!!!!
> > Thanks in advance.
Received on Mon Oct 01 2001 - 16:21:10 CEST