sql server msde: Query Timeout -- sql server msde

Query Timeout

Richard
8/26/2004 5:09:02 PM

sql server msde: I have a query I run in MSDE that will give me a timeout error message. It
reads:
"Timeout expired. The time out period elapsed prior to completion of the
operation or the server is not responding."

I know the server is responding, because the query seems to run anyway,
though I'm not sure the results are accurate. Is there any way to extend the
timeout period so this does not happen. The query running is adding
numerical records to one table based on criteria in the query and values in

Re: Query Timeout

J Young
8/26/2004 10:40:31 PM

What application are you using to query the database? If it's something your
wrote in-house and you are using ADO then set the CommandTimeout property of
the connection to 0 (zero). Some ADO libraries default to 30 seconds for a
timeout.

Jim

[quoted text, click to view]