Re: How to determine current connect string?

From: Steve Shiflett <steven.p.shiflett_at_lmco.com>
Date: 1997/04/09
Message-ID: <334BEBFF.17A8@lmco.com>#1/1

Michael Ho wrote:
>
> Angelito Dizon wrote:
>
> > Michael Ho <infoage_at_hk.super.net> wrote:
> >
> > >> How do I return the current connect string?
> > >>

>
> Sorry, but seems only way to find out connect string is search the
> TNSNAMES.ORA.
Yes, and a moderate pain in the butt to construct... but I did it once and keep it around handy in my text editor to paste into the appropriate place when asked...

My system likes my connect string... which is

*paste*
(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = msivs) (Port = 1526) ) )(CONNECT_DATA = (SID = msi)))

*paste*

Have fun typing that in from memory all the time... Received on Wed Apr 09 1997 - 00:00:00 CDT