bool SetConnection() { if (connAttempts > 25) { if ((connAttempts % 250) != 0) { return(false); } } // retry 25 times, then every 250 attempts try { if (DBMain.ProviderInvariantName.Equals("")) { return(false); } sql_con = DBMain.CreateConnection(useConnStr: true); sql_con.ConnectionString = DBMain.ConnStr; return(true); } catch (Exception caught) { connAttempts++; Console.WriteLine(caught.Message); } return(false); }
public void SetConnection() { if (sql_con == null) { try { if (DBMain.ProviderInvariantName.Equals("")) { return; } sql_con = DBMain.CreateConnection(useConnStr: true); sql_da = DBMain.CreateDataAdapter(); } catch (Exception caught) { DBMain.AltLog(LogLevels.Error, 70100, "Unable to connect with database " + caught.Message); } } }