Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ADO - Oracle

Re: ADO - Oracle

From: Leif Kuschel <Leif.Kuschel_at_t-online.de>
Date: 2000/05/05
Message-ID: <8eugip$9if5o$1@fu-berlin.de>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US