private bool TestOracleConnection(out string errMsg)
{
errMsg = string.Empty;
OracleConnectionStringBuilder oraConnBuilder = new OracleConnectionStringBuilder();
oraConnBuilder.DataSource = this.Server;
oraConnBuilder.UserID = this.UserName;
oraConnBuilder.Password = this.Password;
OPCOracleSQLHelper oraHelper = new OPCOracleSQLHelper(oraConnBuilder.ConnectionString, out errMsg);
try
{
oraHelper.Connected = true;
}
catch (Exception ex)
{
errMsg = ex.Message;
return(false);
}
string querClause = string.Format("SELECT * FROM {0} WHERE ROWNUM <= 1", TableName);
DataTable dt = oraHelper.QueryRecords(querClause, out errMsg);
if (dt == null)
{
return(false);
}
querClause = string.Format("SELECT * FROM {0} WHERE ROWNUM <= 1", HistoryTableName);
dt = oraHelper.QueryRecords(querClause, out errMsg);
return(dt != null);
}
