all groups > sql server odbc > may 2004 >
You're in the

sql server odbc

group:

ODBC timeout


ODBC timeout Danny
5/31/2004 8:47:38 AM
sql server odbc: 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
Re: ODBC timeout Mark Allison
6/2/2004 10:56:42 AM
Danny,

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


[quoted text, click to view]
AddThis Social Bookmark Button