470,849 Members | 1,112 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 developers. It's quick & easy.

Timeout expired

Hey I really need help.

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
  1. <httpRuntime 
  2. maxRequestLength="1048576"
  3. executionTimeout="3600"/>
I also added:
Expand|Select|Wrap|Line Numbers
  1. connection timeout = 60
in the Sql Connection string but still nothing

Here is the error:

Expand|Select|Wrap|Line Numbers
  1. Server Error in '/' Application.
  2. --------------------------------------------------------------------------------
  4. Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. 
  5. 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. 
  7. Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
  9. Source Error: 
  11. 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.  
  13. Stack Trace: 
  16. [SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
  17.    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +862234
  18.    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739110
  19.    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
  20.    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
  21.    System.Data.SqlClient.SqlDataReader.CloseInternal(Boolean closeReader) +175
  22.    System.Data.SqlClient.SqlDataReader.Close() +115
  23.    System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue) +123
  24.    System.Data.SqlClient.SqlCommand.ExecuteScalar() +148
  25.    GetIABFile.Page_Load(Object sender, EventArgs e) +217
  26.    System.Web.UI.Control.OnLoad(EventArgs e) +99
  27.    System.Web.UI.Control.LoadRecursive() +47
  28.    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

I would really appreciate any help I can get. Thanks a lot
Apr 18 '08 #1
1 4906
7,872 Expert 4TB
The timeout in the connectionstring ONLY dictates the timeout for trying to connect to the server.
I am unsure where the query timeout is kept. Possibly only in the management of the SQL server somewhere.
Apr 21 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Silvia | last post: by
5 posts views Thread by Jason | last post: by
3 posts views Thread by Nils Magnus Englund | last post: by
3 posts views Thread by rn5a | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.