private bool TestConnection()
{
BuildConnectionString();
//Check Database Type
if (oDatabaseType == DatabaseTypes.SqlServer)
{
SqlConnection conTest = new SqlConnection(sConnectionString);
try
{
conTest.Open();
}
catch (Exception)
{
return false;
}
conTest.Close();
conTest.Dispose();
}
else if (oDatabaseType == DatabaseTypes.MySql)
{
MySqlConnection conTest = new MySqlConnection(sConnectionString);
try
{
conTest.Open();
}
catch (Exception)
{
return false;
}
conTest.Close();
conTest.Dispose();
}
return true;
}