Post reply

Message: Timeout expired

  • April 16, 2008 at 9:28 am

    #186556

    Hi All,

    My clients (C# code) get Timeout exception when they try to download data and insert them into tables through the stored procedure (SQL Server Express).

    Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

    From client (C#) side they have applied infinite wait option, still they see this error 1-10 times.

    Can any suggest? what should I do in SQL Server Express box to fix this problem.

    Thanks,

    Sri.

  • April 21, 2008 at 6:01 am

    #804888

    [font="Courier New"]Can you check whether you are able to connect to the server using SSMS?? If yes check the process running on the particular database..[/font]

    Regards..Vidhya Sagar
    SQL-Articles

  • April 29, 2008 at 7:32 am

    #808322

    Additional question: is this an occasional error or something that occurs 100% of the time?

  • April 29, 2008 at 8:27 am

    #808390

    Yes frequently (1-6 times).

    Finally I went to SQL Server (SQL Express) ---> properties --->

    connections ---> Allow remote connection to this server = set to 0 (default 600).

    Now I don't see any time out errors.

    I know this was not the right fix, just a time being fix.

    This error is only to client (C#)

    Thanks,

    Sri

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply