Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2013-11-25
3
Medium Priority
?
337 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 2000 total points
ID: 39675751
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
ID: 39676982
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
ID: 39686726
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

721 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