Connection timeout has nothing to do with how long the command takes to
execute.
If you are in fact getting connection timeout errors, your connection pool
might be full.
If you're getting command timeout errors, you need to increase the
commandtimeout property of the Command object being executed.
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.
__________________________________
JDupont said:
I am trying to run as stored procedure in vb.net. When I try to execute
the sp I keep getting a Connection timeout error. I have increased my
timeout property but it continues to timeout. This sp may take quite a long
time to run.
