Solved

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

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with converting xml file to excel using VB.NET 3 25
Text file into sql server 5 32
Convert datetime to time string 10 28
run a stored procedure from vb.net 1 27
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

832 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