ASP.NET - Server Connection Reset

Question

I have a website that from time to time requires I do bulk updates on the Access database and to facilitate this I created a run-once-and-delete page that contains a big text box, a captcha, and a hard coded strong password. When I run this against a local copy of the database I have no problems, but when I run it on the server I get a "Connection with Server Reset" about 3 seconds after clicking submit. Unfortunately the hosting environment is out of my purview so I cannot look at any server-side logs when this happens. I haven't the faintest idea what could be causing this so I was hoping you guys could take a look.

This code is a little ugly just because I didn't really care to spend a lot of time on it (and some of it was written by another developer). Either way, I don't see any obvious functional issues.

protected void btnRunBatch_Click(object sender, EventArgs e)
{
 if (Page.IsValid)
 {
  ArrayList queries = GetSqlStatementArray();
  string results = string.Empty;

  try
  {
   BatchSQLInsert(Application["DBPath"].ToString(), queries);

   if (queries.Count > 0)
   {
    results = "<b>Batch Operation Completed Successfully.</b><br /><br />";
    results += "The following queries were executed:";
    results += "<ul>";
    foreach (string query in queries)
    {
     results += "<li>" + query + "</li>";
    }
    results += "</ul>";

    this.tbxBatchStatement.Text = string.Empty;
   }
   else
   {
    results = "<b>No queries to execute.</b>";
   }
  }
  catch (Exception ex)
  {
   results = "<b>Execution Errors Encountered:</b><br />";
   results += "<ul><li>" + ex.Message + "</li></ul>";
  }

  this.phResults.Controls.Add(new LiteralControl(results));
 }
}

private ArrayList GetSqlStatementArray()
{
 ArrayList queries = new ArrayList();
 string[] lines = this.tbxBatchStatement.Text.Split(new string[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries);
 string lineBuffer = string.Empty;

 foreach (string line in lines)
 {
  if (lineBuffer == string.Empty)
  {
   if ((line.ToUpper().StartsWith("SELECT") || line.ToUpper().StartsWith("INSERT") || line.ToUpper().StartsWith("UPDATE") || line.ToUpper().StartsWith("DELETE")))
   {
    if (line.EndsWith(";"))
     queries.Add(line);
    else
     lineBuffer = line;
   }
  }
  else
  {
   lineBuffer += " " + line;
   if (line.EndsWith(";"))
   {
    queries.Add(lineBuffer);
    lineBuffer = string.Empty;
   }
  }
 }
 return queries;
}

public static void BatchSQLInsert(string DBPath, System.Collections.ArrayList sqlArray)
{
 System.Data.OleDb.OleDbCommand cmd = null;
 System.Data.OleDb.OleDbConnection conn = null;
 System.Data.OleDb.OleDbTransaction myTrans = null;
 int intRecsReturned = 0;
 int i = 0;

 if (sqlArray.Count > 0)
 {
  cmd = new System.Data.OleDb.OleDbCommand();
  conn = GetConnection(DBPath);
  myTrans = conn.BeginTransaction();

  try
  {
   cmd.CommandType = System.Data.CommandType.Text;
   cmd.Connection = conn;
   cmd.Transaction = myTrans;
   while (i < sqlArray.Count)
   {
    cmd.CommandText = (string)(sqlArray[i]);
    intRecsReturned = cmd.ExecuteNonQuery();
    i++;
   }
   myTrans.Commit();
   conn.Close();
  }
  catch (Exception eee)
  {
   myTrans.Rollback();

   throw new Exception("BatchSQLInsert() failed-" + eee.Message + "\r\nArray-" + sqlArray.ToString());
  }
  finally
  {
   if (conn != null)
    conn.Dispose();
   if (cmd != null)
    cmd.Dispose();
  }
 }
}

Answer 1

Sounds like the process is too long running, you might need to adjust it Time Out settings in IIS... :(

Which i know you can't, sorry not really helpful-