Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ADO - Oracle
Hi Mike,
thank you very mutch. I tried it and it works fine.
best regards,
Leif
Michael D. Long <lead_dog_at_bellsouth.net> schrieb in im Newsbeitrag:
KepQ4.408$xI4.167150_at_news2.atl...
>
> 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 Fri May 05 2000 - 00:00:00 CDT