Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
- Posts: 14
- Joined: Wed 11 May 2005 00:09
in 2.5 version (we can't check 3.0 beta) on several computers (not on all) function GetServerList say - "cant find tnsnames.ora"
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
- Posts: 725
- Joined: Thu 28 Oct 2004 14:06
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.