Oracle8/ODBC connect problem

From: PhilC <news_at_macostech.com>
Date: 1 Sep 2001 18:03:38 -0700
Message-ID: <2c42efef.0109011703.6136c05a@posting.google.com>

I'm trying to use Oracle8 and ODBC to connect to two Oracle Database. I can connect to ONE, but NOT THE OTHER ... why!? I think this may have to do with the SERVICE_NAME - see below! (Yes I know about the different PORTs)

This the current Oracle8 (8.1.7) package from Oracle on Win2K, and the DB's are on two separate Solaris7 systems with Oracle 8.1.5.

This is the TNSNAMES.ORA from dsystem01 - I CAN connect to this one: WEBDB =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST =DSYSTEM01 )(PORT = 1522))     )
(CONNECT_DATA =

      (SERVICE_NAME = webdb.world)
    )
  )

This is the TNSNAMES.ORA from system01 - I can NOT connect to this one:
DUMMY1 = (yes that's the real entry)
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = SYSTEM01)(PORT = 1521))     )
(CONNECT_DATA =

      (SERVICE_NAME = dummy1)
    )
  )

On ALL servers, doing select * from global_name;

results is
GLOBAL_NAME

WEBDB.WORLD My TNSNAMES.ORA on my PC looks like:

SYSTEM01 =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = SYSTEM01)(PORT = 1521))     )
(CONNECT_DATA =

      (SERVICE_NAME = dummy1)
    )
  )

DSYSTEM01 =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = DSYSTEM01)(PORT = 1522))     )
(CONNECT_DATA =

      (SERVICE_NAME = webdb.world)
    )
  )

Any assistance most appreciated. Post, or email would be great.

philc@[nospam]macostech.com (remove [nospam] to email) Received on Sat Sep 01 2001 - 20:03:38 CDT