private void Form_Login_Load(object sender, EventArgs e) { //Checks if connection to the DB is possible IDbConnection con = new LogamoastaEntities().Database.Connection; try { con.Open(); //Split the connectionstring, so only the web location of the db will be shown "Verbunden zu eduweb.kb.local" for example string[] connectionsite = con.ConnectionString.Split('=', ';'); lbl_connection.Text = "Verbunden zu '" + connectionsite[1] + "'."; } catch { lbl_connection.Text = "Verbindung zur Datenbank nicht möglich!"; btn_anmelden.Enabled = false; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } if (lbl_connection.Text == "Verbindung zur Datenbank nicht möglich!") { LogamoastaEntities hakkitzcon = new LogamoastaEntities(); //replace the connection with web.hak-kitz.at hakkitzcon.Database.Connection.ConnectionString = hakkitzcon.Database.Connection.ConnectionString.Replace("eduweb.kb.local", "web.hak-kitz.at"); IDbConnection con2 = hakkitzcon.Database.Connection; try { con2.Open(); //Split the connectionstring, so only the web location of the db will be shown "Verbunden zu eduweb.kb.local" for example string[] connectionsite = con2.ConnectionString.Split('=', ';'); lbl_connection.Text = "Verbunden zu '" + connectionsite[1] + "'."; entity.Database.Connection.ConnectionString = hakkitzcon.Database.Connection.ConnectionString; btn_anmelden.Enabled = true; } catch { lbl_connection.Text = "Verbindung zur Datenbank nicht möglich!"; btn_anmelden.Enabled = false; } finally { if (con2.State == ConnectionState.Open) { con2.Close(); } } } }