It is about the message: Timeout Expired

• LACHEZAR LAZAROV

  Newbie

  Points: 4

  More actions

  February 20, 2004 at 6:37 am

  #66257

  What is the problem ?

  I run complicated SQL quire .

  When I use  Query Analyzer it takes me 2:40 minutes to get the rezult - but it is O.K.

  When I use SQL SERVER Enterprise Manager / SQL Pane to start the quire I receive the folloing message 0,5 minutes later: [Microsoft][ODBC SQL Server Driver] Timeout Expired. The result is the same if I use Web Browser and IIS.

  Some Ideas ???

  Thank You !!!

   

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  February 20, 2004 at 8:31 am

  #494938

  Enterprise Manager uses ODBC to run the query, and hence gets the default ODBC timeout (either 30 or 45 seconds, I can't remember which).

  I couldn't find a way of changing this default, so stuck with Query Analyzer

• fhanlon

  SSChampion

  Points: 13131

  More actions

  February 20, 2004 at 9:21 am

  #494948

  see http://vyaskn.tripod.com/watch_your_timeouts.htm for a timeout discussion. It may not help with ODBC connection butit may help with IIS.

  Francis