Page 1 of 1

Multiple Oracle Home

Posted: Thu 06 Oct 2005 11:33
by achib
I use OraDirect 2.5.3

string OracleHome = "c:\orant";

foreach(CoreLab.Oracle.OracleHome h in CoreLab.Oracle.OracleConnection.Homes)
{
Console.WriteLine(h.Path);
if(h.Path.ToUpper() == OracleHome.ToUpper())
{
_cnn.Home = h.Path;
}
} }

when i call _cnn.Open() i get exception Oracle Home with name C:\orant does not exist. Why does not Oracle Home exist, if i select it from the OracleHomeCollection?

Posted: Tue 11 Oct 2005 06:28
by Paul
You must specify Oracle home name instead of its path in OracleConnection.Home property. Plese see h.Name or the value of HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME?\ORACLE_HOME registry key.