I have a Website coded using ASP.NET and VB and for some reason, i'm getting the following error when I try to upload or access a large file which is stored in the database. It was working fine when I was runing the site on the localhost. I added the following line to the web.config file to increase the timeout:
Expand|Select|Wrap|Line Numbers
- <httpRuntime
- maxRequestLength="1048576"
- executionTimeout="3600"/>
Expand|Select|Wrap|Line Numbers
- connection timeout = 60
Here is the error:
Expand|Select|Wrap|Line Numbers
- Server Error in '/' Application.
- --------------------------------------------------------------------------------
- Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
- Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
- Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
- Source Error:
- An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
- Stack Trace:
- [SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
- System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +862234
- System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739110
- System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
- System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
- System.Data.SqlClient.SqlDataReader.CloseInternal(Boolean closeReader) +175
- System.Data.SqlClient.SqlDataReader.Close() +115
- System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue) +123
- System.Data.SqlClient.SqlCommand.ExecuteScalar() +148
- GetIABFile.Page_Load(Object sender, EventArgs e) +217
- System.Web.UI.Control.OnLoad(EventArgs e) +99
- System.Web.UI.Control.LoadRecursive() +47
- System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
I would really appreciate any help I can get. Thanks a lot