Reading installed Oracle TNS names
From: Bruce Galloway <bruceg_at_totalsports.net>
Date: Fri, 14 Jan 2000 13:49:38 -0500
Message-ID: <387F6FC2.24140D77_at_totalsports.net>
[Quoted] We're about to add additional Oracle Net Service Names to our setup. So far we've only had production and test networks for folks to log into and all our apps have been hard coded to these 2 names (yes I know... it was done before I got here!). With the additional names coming soon, I'd like to migrate our apps to be able to read the current Oracle installation and discover what names are installed on the machine. I don't want to have to parse TNSNAMES.ORA file as we may be moving to a name server in the future as well and parsing TNSNAMES.ORA would get me even more behind the curve.
Date: Fri, 14 Jan 2000 13:49:38 -0500
Message-ID: <387F6FC2.24140D77_at_totalsports.net>
[Quoted] We're about to add additional Oracle Net Service Names to our setup. So far we've only had production and test networks for folks to log into and all our apps have been hard coded to these 2 names (yes I know... it was done before I got here!). With the additional names coming soon, I'd like to migrate our apps to be able to read the current Oracle installation and discover what names are installed on the machine. I don't want to have to parse TNSNAMES.ORA file as we may be moving to a name server in the future as well and parsing TNSNAMES.ORA would get me even more behind the curve.
Does anyone out there have example VB code that will let me read available Oracle services either local to the machine, or accesible from an Oracle name server? I'd sure appreciate seeing it!
Thanks
Bruce
Received on Fri Jan 14 2000 - 19:49:38 CET