Timeout expired

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Scorpion657
    New Member
    • Mar 2008
    • 5

    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:

    Code:
    <httpRuntime 
    maxRequestLength="1048576"
    executionTimeout="3600"/>
    I also added:
    Code:
    connection timeout = 60
    in the Sql Connection string but still nothing

    Here is the error:

    Code:
    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
  • Plater
    Recognized Expert Expert
    • Apr 2007
    • 7872

    #2
    The timeout in the connectionstrin g 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.

    Comment

    Working...