Intermittent timeout connections to SQL server from VB application

• vsuresh

  SSC Veteran

  Points: 225

  More actions

  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

• Eric M Russell

  SSC Guru

  Points: 125596

  More actions

  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