Page 1 of 1

how can I find out which Oracle Home the connection is using?

Posted: Wed 06 Jun 2007 10:35
by kevinherring
Hi
As the subject states, I am trying to confirm which Oracle Home the driver is using at run-time.
I can itterate through OracleHomes ok, and print the available ones out.
There is also the OracleConnection.Home property but this is blank, which the documentation says means the default is being used. How can I find out what the default is?

I have no ORACLE_HOME environment variable on my machine; the path to my home is hard coded into the 'path' system variable.

Thanks
Kevin

Posted: Wed 06 Jun 2007 11:04
by Alexey
Try OracleConnection.Homes.DefaultHome.

Posted: Wed 06 Jun 2007 11:09
by kevinherring
oops, didnt see that one hiding in there! Thanks Alexey, that's great.

Posted: Wed 06 Jun 2007 11:36
by Alexey
You are welcome.