time out error while debugging stored procedure from inside visual studo 2010

I have Parametrized  stored procedure and put a break point inside the sp. when i try to debug the sp from vb.net2010 , it works smoothly if i continuously press f8 after hitting the break point. moment i pause for few seconds, i get the above said error.

Can some expert  help me in resolving the issue

thanks in advance
venkataramanaiahsrAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jacques Bourgeois (James Burger)Connect With a Mentor PresidentCommented:
There is a timeout on database operations to prevent an application from freezing if an operation on the server has problems and cannot answer in the specified amount of time. When you are debugging, that timeout period of inactivity can be hit and you receive the error.

Its 15 seconds by default, but you can make it indefinite by adding a ConnecTimeout=0 clause to your ConnectionString. Be sure to reset it to a proper value when not debugging however, because the application would hang in an infinite wait if there is ever a problem with the server.
0
 
venkataramanaiahsrConnect With a Mentor Author Commented:
Thanks for early reply.  But i think it is command timeout and not connection timeout to be set to zero. Any way thanks for pointing me in right direction, based on this i just goggled and got the required solution
0
 
venkataramanaiahsrAuthor Commented:
Thanks for early reply.  But i think it is command timeout and not connection timeout to be set to zero. Any way thanks for pointing me in right direction, based on this i just goggled and got the required solution
0
All Courses

From novice to tech pro — start learning today.