Re: ADO - Oracle

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: 2000/05/05
Message-ID: <8eul1j$hnn$1@soap.pipex.net>#1/1

I use (in vb)

"Data Source=<password>;User ID=<password>;Password=<password>"

The data source is a system dsn using oracle odbc driver 8.1.5

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Leif Kuschel" <Leif.Kuschel_at_t-online.de> wrote in message
news:8erdps$9fsfh$1_at_fu-berlin.de...


> Hi,

>

> today I tried the access to Oracle with ADO.

> For this, I used the following connectionstring:

>

> provider=MSDAORA.1;Server=sname;UID=uname;PWD=pu;DATABASE=tsp;

>

> sname - the servername

> uname - the username

> pu        - the userpassword

> tsp       - the name of an existing tablespace

>

> After calling the open methode, the following error occurs:

>

> code = 80040e4d

> code meaning = IDispatch error #3149

> source = Microsoft OLE DB Provider for Oracle

> description = ORA-01017: invalid username / password; logon denied

>

> It seems there is a problem with the UID-PWD combination. But it's not

 true.


> If I use this

> combination in "Oracle SQL Worksheet" it works.

>

> Who can help ? Did I forgot something in the connectionstring ?

> Did anyone use ADO for Oracle ? Is there any little sample (prefer C++) ?

>

> thanks for your help,

>

> Leif

>

>

>

Received on Fri May 05 2000 - 00:00:00 CDT