Re: Connect string for Oracle running on NT
From: Jeffrey S. McFarlane <jeffmc_at_shellus.com>
Date: 1996/01/26
Message-ID: <DLswqn.BD1_at_shellgate.shell.com>#1/1
)
(CONNECT_DATA =
(SID = DB01)
)
)
Date: 1996/01/26
Message-ID: <DLswqn.BD1_at_shellgate.shell.com>#1/1
In article <4e2ofp$e0r_at_www.basic.net>, lincoln_at_basic.net says...
>
>I have installed Oracle 7.0 on a box running NT. We will be using named
pipes
>to provide client access the database. I did not deviate from any of the
>default settings during installation. What will the connect string look like
>to connect from a client machine?
>
>Thanks,
>Chris Lincoln
>
It uses the standard connect strings for SQL*NET V1 or V2.
V1 - connect user/password_at_p:ics40a1:DB01 V2 - connect user/password_at_db01 -- where the service name is in a TNSNAMES.ORA
file accessed by the client.
section from TNSNAMES.ORA
db01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = pcnt.sic.shell) (PROTOCOL = NMP) (SERVER = ICS40A1) (PIPE = ORAPIPE) )
)
(CONNECT_DATA =
(SID = DB01)
)
)
-- Jeffrey S. McFarlane Oracle DBA Shell Services Company http://www.lookup.com/Homepages/71915/home.html mailto:jeffmc_at_shellus.comReceived on Fri Jan 26 1996 - 00:00:00 CET