February 20, 2004 at 6:37 am
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 !!!
February 20, 2004 at 8:31 am
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
February 20, 2004 at 9:21 am
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
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply