Solved

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

Posted on 2013-11-25
3
327 Views
Last Modified: 2013-11-30
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
0
Comment
Question by:venkataramanaiahsr
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 500 total points
Comment Utility
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
 

Assisted Solution

by:venkataramanaiahsr
venkataramanaiahsr earned 0 total points
Comment Utility
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
 

Author Closing Comment

by:venkataramanaiahsr
Comment Utility
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

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now