Home -> Usenet -> comp.databases.oracle -> Re: [Microsoft][ODBC driver for Oracle][Oracle]ORA-01017: invalid username/password; logon denied

Re: [Microsoft][ODBC driver for Oracle][Oracle]ORA-01017: invalid username/password; logon denied

From: Steve <scoobie_doo_at_e-mailanywhere.com>
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












Original text of this message