ODBC-Error between 7.3.4 and 8.1

From: Roland <rsippel_at_web.de>
Date: 22 Oct 2002 00:46:06 -0700
Message-ID: <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 ?

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 - 09:46:06 CEST

Original text of this message