Parsing tnsnames.ora for know databases

[David Thielen]

Hi;

It seems to me it should be possible to find the tnsnames.ora file on
a user's computer, parse it, and then present the user with a list of
known Oracle databases. These can then be used to create an
OracleConnection.

Does anyone know if this is possible, and if so:

1) How do I find the location of the tnsnames.ora file in use on
someone's computer (I've found 3 of the files on my system so just
searching won't necessarily get the right one).

2) Any suggestions on the best way to parse the file?

Or if someone already has written code for this (did not find it in a
google search) - please post the link.

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[David Thielen]

Never mind.

Google does a lot better if you spell tnsnames correctly - lots of
people have done this.

thanks - dave

Hi;

It seems to me it should be possible to find the tnsnames.ora file on
a user's computer, parse it, and then present the user with a list of
known Oracle databases. These can then be used to create an
OracleConnection.

Does anyone know if this is possible, and if so:

1) How do I find the location of the tnsnames.ora file in use on
someone's computer (I've found 3 of the files on my system so just
searching won't necessarily get the right one).

2) Any suggestions on the best way to parse the file?

Or if someone already has written code for this (did not find it in a
google search) - please post the link.

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm