Problem wqith connection to Oracle

[Daniel Wetzler]

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.

 

[Dmitry Loginov]

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

Seems You use your ODBC DSN name in ConnectionString form OraOLEDB provider.
You should not use one, and there is no need to define ODBC data source
using OraOLEDB provider!
Just specify SQL*Net alias of Your Oracle database as DSN.