public bool TestConnect(string inServerName, string inDBName, WS.Data.DBMSType inDBReside)
{
//return true;
string strConnStr = "PROVIDER=SQLOLEDB; Data Source=" + inServerName + "; Initial Catalog=" + inDBName + ";User ID=fm1234;Password=x2y2;";
return(this.pmTestConnect(strConnStr, inDBReside, "EMCORP"));
}
private bool pmTestConnect(string inConnectStr, WS.Data.DBMSType inDBReside, string inTestTab)
{
string strErrorMsg = string.Empty;
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(inConnectStr, inDBReside);
objSQLHelper.SQLExec("select * from " + inTestTab + " where 0=1", ref strErrorMsg);
return(strErrorMsg == string.Empty);
}