ODBC timeout

Hello
When I try to run a query from Query Analizer it work
fine also if it employ 2:54 (174 second) for display
result, but if I try to run the same query from SQL
Server Enterprise Manager I have the Error Message
"[Microsoft][ODBC SQL Server Driver] Timeout Expired".
Way the Query work in Query Analizer and don't work in
Enterprise Manager and in the application ?
Best regards
DannyDanny,
In EM go to Tools->Options->Advanced Tab. Check that the Query Timeout
is set to an acceptable value - 0 means unlimited. Does that help?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Danny wrote:
> Hello
> When I try to run a query from Query Analizer it work
> fine also if it employ 2:54 (174 second) for display
> result, but if I try to run the same query from SQL
> Server Enterprise Manager I have the Error Message
> "[Microsoft][ODBC SQL Server Driver] Timeout Expired".
> Way the Query work in Query Analizer and don't work in
> Enterprise Manager and in the application ?
> Best regards
> Danny