Problem wqith connection to Oracle

Dear Excel and Oracle Experts,

I have a problem with connecting my Excel Application to an Oracle 10g r2 database
on Win XP, using an ADO connection :

To connect to my database I use an ODBC connection (System-DSN). This one works with other applications, so the settings of it are ok.

If I try to connect using the same DSN-file in my Excel application I get
a runtime error with an error code from Oracle (ORA 12560) which is the normal
error code for wrong connection data.
Since my ODBC connection normally works I assume that I have a problem with writing the connection string to my ADO-connection. I'm a bit unsure whether
I use the right Provider string for my configuration but found only two different Provider strings for Oracle.

Here's my ADO connection string :

"OraOLEDB.Oracle.1;Extended Properties="DSN=ECS-Oracle neu;UID=SYSTEM;PWD=daniel;DBQ=ECS
;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T; RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F; CSR=F;FWC=F;FBS=64000;TLO=O;"" Is there any obvious error or where could be an error ?

Best (but desperate) wishes,

Daniel Wetzler

P.S. : Sorry for posting to more than one groups but I'm not sure where to place it. Received on Mon Feb 20 2006 - 10:25:27 CST