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);
}
}
}
