timeout problem

  • Thread starter Thread starter G. Dean Blake
  • Start date Start date
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
 
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.
__________________________________
 
Back
Top