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.