Re: Reading installed Oracle TNS names

Just an idea.

You could create an .ini file and it put the services as follows:

PROD
DEVL
TEST When your application loads, it reads the 3 lines and put in a drop down list. So your users can enter their name, password and select which database to connect to.

You could also create a .reg file and have it update the windows registry. So, your application can read the list of services from the regustry. This is what we do using PowerBuilder.

Bruce Galloway wrote in message <387F6FC2.24140D77_at_totalsports.net>...
>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 - 23:03:50 CET