How to get Oracle service names

[Xiaoming Qian]

Is there any way to get the existing Oracle service names(Stored in TNSNAMES.ORA) using C#.

[phimix]

What is TNSNAMES.ORA? A table, a file or something else? phi phimix.com :omg:

[Xiaoming Qian]

TNSNAMES.ORA is An Oracle Network Configuration File.The following is a sample file: # TNSNAMES.ORA Network Configuration File: D:\oracle\ora81\network\admin\tnsnames.ora # Generated by Oracle configuration tools. CLCX =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 200.22.10.6)(PORT = 1521))    )    (CONNECT_DATA =      (SID = ORCL) (SERVER = DEDICATED)    )  )

[phimix]

Then you should at least be able to use the System.IO functions like ReadLine(). I don't know if there are any methods specifically for working with Oracle files, but it's quite easy to implement some file reading with System.IO. phi phimix.com :omg: