 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / .NET Framework / ADO.NET / December 2006Connection TimeOut
Good Day to all. I have a store procedure that makes many queries, use cursors and some other complicated calculations. If I run it on Management Studio it takes around 3 minutes and work fine. But when I run it from VB.Net it gives me connection Timeout after only 30 seconds. I have configurate the connection timeout to all possible values. Even 0 seconds that means no timeout. What I'm doing wrong? Try adjusting Command's timeout.  SignatureMiha Markic [MVP C#, INETA Country Leader for Slovenia] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ > Good Day to all. > [quoted text clipped - 4 lines] > connection timeout to all possible values. Even 0 seconds that means no > timeout. What I'm doing wrong? doen's the command assume the values of the connection? > Try adjusting Command's timeout. > [quoted text clipped - 6 lines] >> connection timeout to all possible values. Even 0 seconds that means no >> timeout. What I'm doing wrong? Not for command execution. Connection timeout is amount of time for estabilishing a connection, not executing a command. SignatureMiha Markic [MVP C#, INETA Country Leader for Slovenia] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ > doen's the command assume the values of the connection? > [quoted text clipped - 8 lines] >>> the connection timeout to all possible values. Even 0 seconds that means >>> no timeout. What I'm doing wrong? Many thanks > Not for command execution. Connection timeout is amount of time for > estabilishing a connection, not executing a command. [quoted text clipped - 11 lines] >>>> the connection timeout to all possible values. Even 0 seconds that >>>> means no timeout. What I'm doing wrong? Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.