Post reply

Intermittent timeout connections to SQL server from VB application

  • May 27, 2015 at 1:54 pm

    #308519

    Every now and then I get these timeout connections, the message is shown below. What are the steps to take to resolve this?

    Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

    Source: .Net SqlClient Data Provider

    Stack: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

    at System.Data.SqlClient.SqlDataReader.get_MetaData()

    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteReader()

    at iMIS_Keyscan.iMIS_Keyscan.Process_iMIS_Updates() in C:\Derive\iMIS_Keyscan\iMIS_Keyscan.vb:line 71

    at iMIS_Keyscan.Startup.Main() in C:\Derive\iMIS_Keyscan\Startup.vb:line 47

  • May 27, 2015 at 3:17 pm

    #1801110

    The default timeout can be overridden at connection or command level within VB programming code.

    http://stackoverflow.com/questions/1354271/timeout-setting-for-sql-server

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 2 posts - 1 through 1 (of 1 total)

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