Solved

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

Posted on 2013-11-25
3
329 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
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

867 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

17 Experts available now in Live!

Get 1:1 Help Now