ADO - Oracle

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

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