timeout problem

G

G. Dean Blake

I have a delete statement that when run from Query Analyzer takes about 45
minutes to complete. When I put that statement into a dataAdapter and
execute with an ExecuteNonQuery, it gets a timeout after a few seconds. How
can I keep this long running process from getting a timeout? Putting
Connection Timeout=3000 in my connect string did no good.
Thanks,
G
 
W

William \(Bill\) Vaughn

Connection timeout does not impact CommandTimeout. Set the CommandTimeout
property of the Command object.
hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connection TimeOut 4
Connection String - how to include timeout? 5
Connection timeout 3
Connection Timeout 1
DataAdapter.Fill(Dataset) shows timeout error. 2
Dataadapter.Update fails intermittendly when updating large database 3
ConnectionString Timeout After 60 seconds 1
SQLAdapter Timeout doesn't work 6

Top