Re: ADO - Oracle

Server=sname, where sname = the server name is incorrect. This should be the database alias that you are using when you connect via SQL Worksheet.

Mike

"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 Thu May 04 2000 - 00:00:00 CDT