title: Response.Redirect not working in Global.asax
body: <p>I have created an error page to show a general message for all unhandled exceptions.</p>
  
  <p>This is the code in Global.asax</p>
  
  <pre><code>HttpContext ctx = HttpContext.Current;
  
              string e404_PAGE = ctx.Request.AppRelativeCurrentExecutionFilePath.ToString();
              string e404_LINE = ctx.Server.GetLastError().InnerException.StackTrace.Substring(ctx.Server.GetLastError().InnerException.StackTrace.LastIndexOf(":line ") + 6, ctx.Server.GetLastError().InnerException.StackTrace.Substring(ctx.Server.GetLastError().InnerException.StackTrace.LastIndexOf(":line ") + 6).IndexOf(" ")).ToString();
              string e404_MESSAGE = ctx.Server.GetLastError().InnerException.Message.ToString();
              string e404_METHODNAME = ctx.Server.GetLastError().InnerException.TargetSite.ToString();
              string e404_STACKTRACE = ctx.Server.GetLastError().InnerException.StackTrace.ToString();
              string e404_URL = ctx.Request.Url.ToString();
              string e404_DATE = ctx.Timestamp.ToString("yyyy-MM-dd HH:mm:ss");
              string e404_USER = ctx.User.Identity.Name.ToString();
              string e404_IP = ctx.Request.UserHostAddress.ToString();
  
              // * * * //
  
              System.Data.SqlClient.SqlConnection sql_conn;
              sql_conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["myConnectionString"].ToString());
              sql_conn.Open();
              string query = @"insert into UnhandledExceptions(Message, Page, Line, MethodName, StackTrace, URL, Date, [User], IP) 
                                           values(@Message, @Page, @Line, @MethodName, @StackTrace, @URL, @Date, @User, @IP)
                                           select scope_identity();";
              System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(query, sql_conn);
              com.Parameters.AddWithValue("@Message", e404_MESSAGE);
              com.Parameters.AddWithValue("@Page", e404_PAGE);
              com.Parameters.AddWithValue("@Line", e404_LINE);
              com.Parameters.AddWithValue("@MethodName", e404_METHODNAME);
              com.Parameters.AddWithValue("@StackTrace", e404_STACKTRACE);
              com.Parameters.AddWithValue("@URL", e404_URL);
              com.Parameters.AddWithValue("@Date", e404_DATE);
              com.Parameters.AddWithValue("@User", e404_USER);
              com.Parameters.AddWithValue("@IP", e404_IP);
  
              string e404_ID = com.ExecuteScalar().ToString();
  
              sql_conn.Close();
  
              // * * * //            
  
              Session["e404_ID"] = e404_ID;
              Response.Redirect("~/Error.aspx");
  </code></pre>
  
  <p>When I publish the website, the user is not being redirected to the error page.</p>
  
  <p>All the code until the last line works fine. Any suggestion?</p>