2.5 - GetServerList cant find tnsnames

expas · Post by **expas** » Fri 13 May 2005 21:24

in 2.5 version (we can't check 3.0 beta) on several computers (not on all) function GetServerList say - "cant find tnsnames.ora"

in registry:

Code: Select all

(string)(Registry.LocalMachine.OpenSubKey(@"software\oracle").GetValue("oracle_home")) + @"\network\ADMIN\TNSNAMES.ORA";

on this mashines all ok - our own algorithm of finding tnsnames.ora find and parse this file without any error

so may by you say here what is algorithm of finding tnsnames.ora?
and check this in 3.0 version

Paul · Post by **Paul** » Tue 17 May 2005 08:53

GetServerList function in OraDirect .NET 2.50 returns list of servers from tnsnames.ora in default home (not every particular home). Default home in this function is determined from SOFTWARE\ORACLE\ALL_HOMES\DEFAULT_HOME key. It is not correct, because oci.dll is taken from default home determined by environment PATH variable. We will correct this in OraDirect .NET 3.0.