public IDbConnection BuildConnection(string driver, string connectionString) { IDbConnection conn = null; switch (driver.ToUpper()) { case MyMetaDrivers.MySql2: conn = new MySqlConnection(connectionString); break; case MyMetaDrivers.PostgreSQL: case MyMetaDrivers.PostgreSQL8: conn = new NpgsqlConnection(connectionString); break; case MyMetaDrivers.Firebird: case MyMetaDrivers.Interbase: conn = new FbConnection(connectionString); break; case MyMetaDrivers.SQLite: conn = new SQLiteConnection(connectionString); break; #if !IGNORE_VISTA case MyMetaDrivers.VistaDB: try { var mh = new MetaHelper(); conn = mh.GetConnection(connectionString); } catch { throw new Exception("Invalid VistaDB connection or VistaDB not installed"); } break; #endif default: break; } return(conn); }