Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ADO - Oracle
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...Received on Fri May 05 2000 - 00:00:00 CDT
> 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
>
>
>