From: "Niall Litchfield" <n-litchfield@audit-commission.gov.uk>
Subject: Re: ADO - Oracle
Date: 2000/05/05
Message-ID: <8eul1j$hnn$1@soap.pipex.net>#1/1
References: <8erdps$9fsfh$1@fu-berlin.de>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: abuse@uk.uu.net
X-Trace: soap.pipex.net 957536115 18167 193.128.236.219 (5 May 2000 14:15:15 GMT)
Organization: UUNET WorldCom server (post doesn't reflect views of UUNET WorldCom
X-MSMail-Priority: Normal
NNTP-Posting-Date: 5 May 2000 14:15:15 GMT
Newsgroups: comp.databases.oracle.misc


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@t-online.de> wrote in message
news:8erdps$9fsfh$1@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
>
>
>