Very Computer

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 ?

: 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 *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)==-