Connection TimeOut

[Henrry Pires]

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?

 

[Miha Markic [MVP C#]]

Try adjusting Command's timeout.

 

[Henrry Pires]

doen's the command assume the values of the connection?

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/

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?

 

[Miha Markic [MVP C#]]

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/

doen's the command assume the values of the connection?

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/

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?

 

[Henrry Pires]

Many thanks

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/

doen's the command assume the values of the connection?

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
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?