/// <summary>
/// 获取TNS信息
/// Columns:InstanceName,ServerName,ServiceName,Protocol,Port
/// </summary>
/// 需要安装ODP.NET
/// <returns></returns>
internal static DataTable GetTNSInstance()
{
try
{
System.Data.Common.DbProviderFactory factory =
System.Data.Common.DbProviderFactories.GetFactory("Oracle.DataAccess.Client");
if (factory.CanCreateDataSourceEnumerator)
{
System.Data.Common.DbDataSourceEnumerator dsenum = factory.CreateDataSourceEnumerator();
return(dsenum.GetDataSources()); //InstanceName,ServerName,ServiceName,Protocol,Port
}
}
catch { }
return(null);
}