public void TestSqlConnection(DataBaseServer server)
{
string str = @"data source={servername};initial catalog={dabasename};Integrated Security=false; User ID={userid}; Password={password};";
str = str.Replace("{servername}", server.Machine.MachineName);
str = str.Replace("{dabasename}", server.DataBaseName);
AccessAccount acc = new AccessAccount();
if (server.DBAccount == null)
{
bGomlaDBreportEntities db = new bGomlaDBreportEntities();
acc = db.AccessAccounts.FirstOrDefault(x => x.AccountID == server.DataBaseAccountID);
}
else
{
acc = server.DBAccount;
}
str = str.Replace("{userid}", acc.AccountName);
str = str.Replace("{password}", acc.AccountPassword);
SqlConnection con = new SqlConnection(str);
try
{
con.Open();
}
catch (Exception e)
{
addError(e.Message);
}
}
