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

In article <8219003a.0110010621.6e31918d_at_posting.google.com>, Steve says...

You ever tried the odbc-test-program in your %oracle_home%\odbc folder? You can connect with "oraconn " and "system/manager" as well as with "secdes1/secdes1". BTW, first thing after setting up db should be to change pw's.

Hth
Matthias

>
>** This is the connection string that doesn't work:
>
>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 Tue Oct 02 2001 - 13:48:59 CEST