如题:)
谢谢。贡献一段代码,监测主机是否存在Sqlserver数据库。 private bool GetSqlServerInfo(string strHostName)
{
bool bolConnectionInfo = false;
SQLDMO.Application sap = new SQLDMO.ApplicationClass();
SQLDMO.NameList servers = sap.ListAvailableSQLServers();
string _strHostName = string.Empty;
if (strHostName.ToUpper() == Dns.GetHostName().ToUpper())
{
_strHostName = "(local)";
}
else
{
_strHostName = strHostName;
} for (int i = 0; i < servers.Count; i++)
{
object svr = servers.Item(i + 1); if (string.Equals(_strHostName, svr.ToString()))
{
bolConnectionInfo = true;
break;
}
}
return bolConnectionInfo;
}
谢谢。贡献一段代码,监测主机是否存在Sqlserver数据库。 private bool GetSqlServerInfo(string strHostName)
{
bool bolConnectionInfo = false;
SQLDMO.Application sap = new SQLDMO.ApplicationClass();
SQLDMO.NameList servers = sap.ListAvailableSQLServers();
string _strHostName = string.Empty;
if (strHostName.ToUpper() == Dns.GetHostName().ToUpper())
{
_strHostName = "(local)";
}
else
{
_strHostName = strHostName;
} for (int i = 0; i < servers.Count; i++)
{
object svr = servers.Item(i + 1); if (string.Equals(_strHostName, svr.ToString()))
{
bolConnectionInfo = true;
break;
}
}
return bolConnectionInfo;
}
顺便问一下,你的SQLDMO的引用的是哪个dll,或者引用名称是什么?