Connection Timeout

I have a question about the "Connection Timeout" from the
client to the Sql server. Everything works fine when I
change the "connection timeout" property in the
connection string for the scenario: "the machine is alive
but the sql server is down" but in the scenario that the
network connection to the server is lost I get a very
long timeout.
Any Ideas?
Hi Peter,
How long did you set it to? The default is usually pretty good. The only
times we find we need to change it is over an Internet connection.
Regards,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Peter Ericsson" <peter.l.ericsson@.ericsson.com> wrote in message
news:0c4901c509d3$ef53e790$a401280a@.phx.gbl...
>I have a question about the "Connection Timeout" from the
> client to the Sql server. Everything works fine when I
> change the "connection timeout" property in the
> connection string for the scenario: "the machine is alive
> but the sql server is down" but in the scenario that the
> network connection to the server is lost I get a very
> long timeout.
> Any Ideas?
>
|||I have tried values from 2 to 15 seconds but I don't
think that that is the problem. Because everything works
fine if the SQL Server is down, I get my timeout
depending on the setting. The problem occurs when the
machine that is running the Sql server loses the network
connection, then I get a timout after about 50 seconds.
/Peter

>--Original Message--
>Hi Peter,
>How long did you set it to? The default is usually
pretty good. The only
>times we find we need to change it is over an Internet
connection.
>Regards,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"Peter Ericsson" <peter.l.ericsson@.ericsson.com> wrote
in message[vbcol=seagreen]
>news:0c4901c509d3$ef53e790$a401280a@.phx.gbl...
the[vbcol=seagreen]
alive[vbcol=seagreen]
the
>
>.
>
|||Maybe the following apply to your situation:
TCP/IP Settings for SQL Server Drivers When Pooling Is
Disabled
http://support.microsoft.com/?id=328476
PRB: "WSAEADDRESSINUSE" Error Message When You Try to
Connect Through an Anonymous Port After You Increase the
IMAP Connection Limit
http://support.microsoft.com/?id=319502
-Sue
On Thu, 3 Feb 2005 04:27:01 -0800, "Peter Ericsson"
<peter.l.ericsson@.ericsson.com> wrote:
[vbcol=seagreen]
>I have tried values from 2 to 15 seconds but I don't
>think that that is the problem. Because everything works
>fine if the SQL Server is down, I get my timeout
>depending on the setting. The problem occurs when the
>machine that is running the Sql server loses the network
>connection, then I get a timout after about 50 seconds.
>/Peter
>pretty good. The only
>connection.
>in message
>the
>alive
>the
|||Hi what kind of query your run?
how many records affected by your query?
"Peter Ericsson" <peter.l.ericsson@.ericsson.com> wrote in message
news:0c4901c509d3$ef53e790$a401280a@.phx.gbl...
>I have a question about the "Connection Timeout" from the
> client to the Sql server. Everything works fine when I
> change the "connection timeout" property in the
> connection string for the scenario: "the machine is alive
> but the sql server is down" but in the scenario that the
> network connection to the server is lost I get a very
> long timeout.
> Any Ideas?
>