Forming an SQL*Plus connect string?

From: <laredotornado_at_zipmail.com>
Date: 13 Jan 2006 07:38:10 -0800
Message-ID: <1137166690.177892.69780@o13g2000cwo.googlegroups.com>

Hi,

Simple question, so hopefully there's a simple answer. I just installed Oracle 9i client (9.2.0.1.0) for Windows XP. I fired up SQL*Plus and am trying to connect to our db server. I am asked for username, password, and host connect string. How do I build that? Our admin gave us this tnsnames entry

myserver.mydomain.com =
  (DESCRIPTION =
(ADDRESS_LIST =

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

      (SERVICE_NAME = myservername1)
    )
)

How do I use the above information to build a host connect string?

Thanks, -Dave Received on Fri Jan 13 2006 - 09:38:10 CST