private void cmdTestConnection_Click(object sender, EventArgs e)
{
DatabaseConnectionControl1.RefreshOptions();
var connectString = DatabaseConnectionControl1.ImportOptions.GetConnectionString();
var valid = DatabaseHelper.TestConnectionString(connectString);
if (valid)
{
MessageBox.Show("Connection Succeeded.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("The information does not describe a valid connection string.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmdTestConnection_Click(object sender, EventArgs e)
{
try
{
//SQL
if (optDatabaseTypeSQL.Checked)
{
DatabaseConnectionControl1.RefreshOptions();
var connectString = DatabaseConnectionControl1.ImportOptions.GetConnectionString();
var importDomain = new nHydrate.DataImport.SqlClient.ImportDomain();
var databaseHelper = importDomain.DatabaseDomain;
var valid = databaseHelper.TestConnectionString(connectString);
if (valid)
{
MessageBox.Show("Connection Succeeded.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("The information does not describe a valid connection string.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (optDatabaseTypePostgres.Checked) //Postgres
{
if (DslPackage.Objects.Postgres.ImportDomain.TestConnection(txtConnectionStringPostgres.Text))
{
MessageBox.Show("Connection Succeeded.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("The information does not describe a valid connection string.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Unknown database type.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show("An error has occurred.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
