Re: SQL*Net V2 connect string
Date: 15 Feb 1995 07:09:31 GMT
Message-ID: <3hs9bb$d43_at_dcsun4.us.oracle.com>
Roger Bjarevall <ebcrbj_at_ebc.ericsson.se> writes:
|> Using SQL*Net V1 did it easy to supply the full connect string
|> after the '_at_' sign.
|>
|> My question is how to the same using V2?
|>
|> I have tried something like this but it does not work:
|>
|> sqlplus scott/smith_at_(ADDRESS = \
|> (COMMUNITY = SEA) \
|> (PROTOCOL = TCP) \
|> (HOST = sea25) \
|> (PORT = 2767))
|>
|> Roger Bjärevall
First off the correct syntax would start out something like (DESCRIPTION=(ADDRESS=...)(CONNECT_DATA=...)). Assuming you are on Unix, you could place that whole string within single quotes on the command line. Be forewarned though that Oracle may not support doing this in future releases and will make it mandatory to place a tnsnames alias after the _at_.
Roderick Manalac
Oracle Corporation
DISCLAIMER: My time my opinions.
Received on Wed Feb 15 1995 - 08:09:31 CET