Connection Timeout

[Thomas Kehl]

Hello.

I am trying to connect to a SQLServer. Now, it takes long time to detect, if
the server is available or not. I think, the parameter Connection Timeout
from the ConnectionString will be used to set the Time. Now it takes about
15 s (Default of Connection Timeout). When I set this parameter to 5s, there
is now effect. It will still takes 15s. Can anybody help me?

Thanks
Thomas

 

[Guest]

The connection Time out parameter is not used to set set the length of time
it will take to create a connection to a database. This parameter specifies
the maximum amount of time that is allowed before an connection time out
exception is thrown back. In your case you cannot change how long it will
take to connect to the database by changing this parameter alone.