Main Page 
PC Review
Forums
Newsgroups
Microsoft DotNet
Microsoft ADO .NET
Connection TimeOut
Forums
Newsgroups
Microsoft DotNet
Microsoft ADO .NET
Connection TimeOut
 |
Connection TimeOut |
|
|
Thread Tools | Rate Thread |
28-12-2006, 11:21 AM
|
#1 |
|
Guest
Posts: n/a
|
Connection 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? |
|
|
28-12-2006, 11:27 AM
|
#2 |
|
Guest
Posts: n/a
|
Re: Connection TimeOut
Try adjusting Command's timeout.
-- Miha Markic [MVP C#, INETA Country Leader for Slovenia] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ "Henrry Pires" <henrry.pires_a_acinet,pt> wrote in message news:edn0QJnKHHA.3552@TK2MSFTNGP03.phx.gbl... > 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? > > |
|
|
|
28-12-2006, 02:05 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: Connection TimeOut
doen's the command assume the values of the connection?
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message news:BF1AF47C-DB6D-45A9-B244-804165B83369@microsoft.com... > Try adjusting Command's timeout. > > -- > Miha Markic [MVP C#, INETA Country Leader for Slovenia] > RightHand .NET consulting & development www.rthand.com > Blog: http://cs.rthand.com/blogs/blog_with_righthand/ > > "Henrry Pires" <henrry.pires_a_acinet,pt> wrote in message > news:edn0QJnKHHA.3552@TK2MSFTNGP03.phx.gbl... >> 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? >> >> > |
|
|
|
28-12-2006, 02:21 PM
|
#4 |
|
Guest
Posts: n/a
|
Re: Connection TimeOut
Not for command execution. Connection timeout is amount of time for
estabilishing a connection, not executing a command. -- Miha Markic [MVP C#, INETA Country Leader for Slovenia] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ "Henrry Pires" <henrry.pires_a_acinet,pt> wrote in message news:eXtP$koKHHA.3424@TK2MSFTNGP02.phx.gbl... > doen's the command assume the values of the connection? > > "Miha Markic [MVP C#]" <miha at rthand com> wrote in message > news:BF1AF47C-DB6D-45A9-B244-804165B83369@microsoft.com... >> Try adjusting Command's timeout. >> >> -- >> Miha Markic [MVP C#, INETA Country Leader for Slovenia] >> RightHand .NET consulting & development www.rthand.com >> Blog: http://cs.rthand.com/blogs/blog_with_righthand/ >> >> "Henrry Pires" <henrry.pires_a_acinet,pt> wrote in message >> news:edn0QJnKHHA.3552@TK2MSFTNGP03.phx.gbl... >>> 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? >>> >>> >> > > |
|
|
|
29-12-2006, 09:27 AM
|
#5 |
|
Guest
Posts: n/a
|
Re: Connection TimeOut
Many thanks
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message news:3A52908B-2F93-4AAA-BE70-2D9F3FD84B74@microsoft.com... > Not for command execution. Connection timeout is amount of time for > estabilishing a connection, not executing a command. > > -- > Miha Markic [MVP C#, INETA Country Leader for Slovenia] > RightHand .NET consulting & development www.rthand.com > Blog: http://cs.rthand.com/blogs/blog_with_righthand/ > > "Henrry Pires" <henrry.pires_a_acinet,pt> wrote in message > news:eXtP$koKHHA.3424@TK2MSFTNGP02.phx.gbl... >> doen's the command assume the values of the connection? >> >> "Miha Markic [MVP C#]" <miha at rthand com> wrote in message >> news:BF1AF47C-DB6D-45A9-B244-804165B83369@microsoft.com... >>> Try adjusting Command's timeout. >>> >>> -- >>> Miha Markic [MVP C#, INETA Country Leader for Slovenia] >>> RightHand .NET consulting & development www.rthand.com >>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/ >>> >>> "Henrry Pires" <henrry.pires_a_acinet,pt> wrote in message >>> news:edn0QJnKHHA.3552@TK2MSFTNGP03.phx.gbl... >>>> 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? >>>> >>>> >>> >> >> > |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
