private bool TestMSSQLConnection(out string errMsg) { errMsg = string.Empty; SqlConnectionStringBuilder sqlConnBuilder = new SqlConnectionStringBuilder(); sqlConnBuilder.DataSource = this.Server; sqlConnBuilder.InitialCatalog = this.Database; sqlConnBuilder.UserID = this.UserName; sqlConnBuilder.Password = this.Password; OPCMSSQLHelper sqlHelper = new OPCMSSQLHelper(sqlConnBuilder.ConnectionString, out errMsg); try { sqlHelper.Connected = true; } catch (Exception ex) { errMsg = ex.Message; return(false); } string querClause = string.Format("SELECT TOP 1 * FROM {0}", TableName); DataTable dt = sqlHelper.QueryRecords(querClause, out errMsg); if (dt == null) { return(false); } querClause = string.Format("SELECT TOP 1 * FROM {0}", HistoryTableName); dt = sqlHelper.QueryRecords(querClause, out errMsg); return(dt != null); }
public override bool CreateConnection(out string errMsg) { errMsg = string.Empty; SqlConnectionStringBuilder sqlConnBuilder = new SqlConnectionStringBuilder(); sqlConnBuilder.DataSource = this.m_server; sqlConnBuilder.InitialCatalog = this.m_database; sqlConnBuilder.UserID = this.m_userName; sqlConnBuilder.Password = this.m_password; this.m_sqlHelper = new OPCMSSQLHelper(sqlConnBuilder.ConnectionString, out errMsg); try { this.m_sqlHelper.Connected = true; this.m_sqlHelper.Connected = false; return(true); } catch (Exception ex) { errMsg = ex.Message; OPCLog.Error(string.Format("创建 MS SQL Server 数据库连接时发生错误:{0}", errMsg)); return(false); } }