Re: ODBC-Error between 7.3.4 and 8.1

rsippel_at_web.de (Roland) wrote in message news:<420701cc.0210212346.7d8d8c39_at_posting.google.com>...
> Hey _at_ all
> the Macromedia Dreamworker (Ultradev MX) group can´t help.
> It seems an Oracle problem !!
>
> I have installed on Client: Oracle 7.3.4 AND Oracle 8.1 and here is an
> ODBC-Problem. A Programm use the wrong oracle ORCL (see logfile )!
> Does this two version not work together with ODBC ?

Oracle 7.3.4 is not multi-home compliant. That is, it does not allow you to install any other version of the Oracle client on the same machine. If you care about running a supported configuration, you'll have to go with one or the other version of the client.

If you're not concerned about having a supported configuration, and don't care about Oracle support, etc. you may be able to work around this problem by modifying your PATH environment variable to put whichever %ORACLE_HOME% you want to use first in the path. Of course, this would fail if you need to run both clients simultaneously.

Justin Cave

>
> Use: ARGV0=oracle80ORCL
> but it must use: ARGV0=oracle73ORCL
>
> System: W2K (SP2) und MDAC 2.6 (SP2)
> Driver: msorcl32.dll
> Microsoft Data Access - ODBC-Treiber for Oracle Version: 2.573.6526.0
> ODBC-Programm: Macromedia Dreamweaver MX (6.0)
>
> !! The same DSN-Name works fine with other Programms (ODBC-Test,
> Access, etc.).
>
> I can connect with ALL other programs to this DSN but NOT with DW MX.
> DSN: DW MX -> Database DSN -> Test Connection:
> -----
> [Microsoft] ODBC Driver for Oracle [Oracle] ORA-12154: TNS :could not
> resolve service name.
> [Microsoft][ ODBC Driver Manager ]Error during SQLSetConnectAttr-Call
> for Driver.
> -----
>
> DW MX use wrong connection for ODBC - how you setup this in MX
> (ARGV0=oracle80ORCL)??
> DSN-Name is for Oracle 7.3.4 NOT Oracle 8.1
>
> ----sql.log----
> Fatal OSN connect error 12154, connecting to: dia3.world
>
> VERSION INFORMATION:
> TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
> Time: 16-OKT-02 13:23:43
> Tracing not turned on.
>
> **************************************
> Fatal OSN connect error 12547, connecting to:
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)
> (ARGV0=oracle80ORCL)
> (ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))
> (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=Dreamweaver.exe)
> (HOST=CBK5144)(USER=admin))))
>
> VERSION INFORMATION:
> TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
> Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
> 2.3.4.0.0 - Production
> Time: 16-OKT-02 13:23:43
> Tracing not turned on.
> Tns error struct:
> nr err code: 12206
> TNS-12206: TNS: TNS-Fehler während der Navigation erhalten.
> ns main err code: 12547
> TNS-12547: TNS: Verbindung verloren
> ns secondary err code: 12560
> nt main err code: 517
> TNS-00517: Verbindung verloren
> nt secondary err code: 0
> nt OS err code: 0
> ----------
> Thanks
> Roland
Received on Tue Oct 22 2002 - 22:33:16 CEST