Connection TimeOut

  • Thread starter Thread starter Henrry Pires
  • Start date Start date
H

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?
 
doen's the command assume the values of the connection?

Miha Markic said:
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 said:
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?
Click to expand...
Click to expand...
 
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 said:
doen's the command assume the values of the connection?

Miha Markic said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Many thanks
Miha Markic said:
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 said:
doen's the command assume the values of the connection?

Miha Markic said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top