Re: I do not want to use TNSNAMES.ORA. How ?

In article <01bd146c$26e49520$d205a8c0_at_venus>, Oron Vexler <ovexler_at_netvision.net.il> writes
>Hi,
>Is there a way I can connect to a remote database without using alias name
>-
>I mean specify the exact location of the database.
>
>Thanx alon

You don't need to use tnsnames.ora if you specify the complete connect string within your connection i.e. the whole bit associated with the alias within tnsnames.

e.g. in the following, instead of referring to cms_oracle in your connection you'd refer to the whole (DESCRIPTION... ) string.

cms_oracle.world =
  (DESCRIPTION =

        (ADDRESS = 
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = 10.1.0.4)
          (Port = 1526)
        )
      (CONNECT_DATA = 
        (SID = clk)
           (GLOBAL_NAME = cms_oracle.world)
      )

Andy

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG