Re: Problem wqith connection to Oracle

"Daniel Wetzler" <Daniel.Wetzler_at_sig.biz> wrote in message news:1140452727.232886.80690_at_o13g2000cwo.googlegroups.com...
> 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.

> 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 Thu Mar 02 2006 - 04:49:56 CST