Re: Oracle8/ODBC connect problem

try to change you servername to ip address,maybe it will work! PhilC <news_at_macostech.com> wrote in message news:2c42efef.0109011703.6136c05a_at_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_at_[nospam]macostech.com (remove [nospam] to email)
Received on Sun Sep 02 2001 - 03:39:09 CEST