Re: TNSNAMES.ORA (Client/Server) and ODBC.INI

From: Michael Carmack <mcarmack_at_freenet.columbus.oh.us>
Date: 1997/05/01
Message-ID: <5ka4lj$5cp@login.freenet.columbus.oh.us>#1/1

RJSchulzSJ (rjschulzsj_at_aol.com) wrote:

: can anybody send me examples of tnsnames.ora files on server and client ?
: how have i to edit the local odbc.ini for connect ?
: does odbc and tnsnames communicate ? if yes, how ?

Using SQL*Net V2, all you need to do in the ODBC Administrator is to supply the connect string for a database, as found in TNSNAMES.ORA. ODBC does not directly read TNSNAMES.ORA; ODBC communicates with the SQL*Net drivers, which reads TNSNAMES.ORA.

Here's the TNSNAMES.ORA file I use on TCP/IP enabled clients. It describes two databases, RSCRAS and RASTEST. The DECNet portions are commented out because the SQL*Net drivers see it first and choke rather than continuing and trying the other specifiec protocol, TCP/IP. I don't know why. On DECNet clients and on the servers, those lines are uncommented.

################

# Filename......: tnsnames.ora

################

RASTEST.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
# (ADDRESS =
# (COMMUNITY = DNT.world)
# (PROTOCOL = DECNet)
# (Node = REHAB2)
# (Object = LSNR-1)
# )

        (ADDRESS = 
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = REHAB2)
          (Port = 1527)
        )
        (ADDRESS = 
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = REHAB2)
          (Port = 1528)
        )

    )
    (CONNECT_DATA =

      (SID = RSCRAS)
         (GLOBAL_NAME = RASTEST.world)

    )
  )
RSCRAS.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
# (ADDRESS =
# (COMMUNITY = DNT.world)
# (PROTOCOL = DECNet)
# (Node = RSCNET)
# (Object = LSNR-1)
# )

        (ADDRESS = 
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = RSCNET)
          (Port = 1527)
        )
        (ADDRESS = 
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = RSCNET)
          (Port = 1528)
        )

    )
    (CONNECT_DATA =

      (SID = RSCRAS)
         (GLOBAL_NAME = RSCRAS.world)

    )
  )

-- 
========================================================================
"Villains, I say to you now:       |   Mike Carmack
 KNOCK OFF ALL THAT EVIL!"         |   Vulcan Dragon -==(UDIC)==-
    S P O O N !!!!    - The Tick   |   mcarmack_at_freenet.columbus.oh.us

Received on Thu May 01 1997 - 00:00:00 CDT