/// <summary>
/// Handles event when Ok button is clicked
/// </summary>
/// <param name="param"></param>
/// <remarks></remarks>
private void OkCommandClick(object param)
{
OdbcConnection cn;
try
{
cn = new OdbcConnection(_connStrBuilder.ConnectionString);
cn.Open();
cn.Close();
if (DbOdbc.GetBackend(cn) == Backends.Access)
{
_defaultSchema = String.Empty;
}
this.RequestClose(_connStrBuilder.ConnectionString, _defaultSchema, null);
}
catch (OdbcException exOdbc)
{
MessageBox.Show("ODBC Server responded with an error:\n\n" + exOdbc.Message,
"ODBC Server Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally { cn = null; }
}
public static Backends GetBackend(string connString, ConnectionTypes connType)
{
switch (connType)
{
case ConnectionTypes.ODBC:
return(DbOdbc.GetBackend(connString));
case ConnectionTypes.OleDb:
return(DbOleDb.GetBackend(connString));
default:
return(Backends.Undetermined);
}
}
private void LoadSchemata()
{
List <String> schemaList = new List <String>();
OdbcConnection cn = null;
try
{
if ((_connStrBuilder != null) && !String.IsNullOrEmpty(_connStrBuilder.ConnectionString))
{
cn = new OdbcConnection(_connStrBuilder.ConnectionString);
cn.Open();
_backend = DbOdbc.GetBackend(cn);
if (_backend != Backends.Access)
{
OdbcCommand cmd = cn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT SCHEMA_NAME FROM information_schema.schemata" +
" WHERE SCHEMA_NAME <> 'INFORMATION_SCHEMA'";
OdbcDataAdapter adapter = new OdbcDataAdapter(cmd);
DataTable dbTable = new DataTable();
try
{
adapter.Fill(dbTable);
schemaList = (from r in dbTable.AsEnumerable()
let schemaName = r.Field <string>("SCHEMA_NAME")
select schemaName).OrderBy(s => s).ToList();
_defaultSchema = DbBase.GetDefaultSchema(_backend, _connStrBuilder, schemaList);
}
catch { }
}
}
}
catch (Exception ex)
{
_connStrBuilder.Dsn = String.Empty;
if (ex is OdbcException)
{
MessageBox.Show(ex.Message, "ODBC Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
MessageBox.Show(ex.Message, "HLU Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
finally
{
if ((cn != null) && (cn.State != ConnectionState.Closed))
{
cn.Close();
}
_schemata = schemaList;
OnPropertyChanged("Schemata");
if (_schemata.Count == 1)
{
_defaultSchema = _schemata[0];
}
OnPropertyChanged("DefaultSchema");
}
}
