Do you change the connection timeout to 5 seconds?
Last updated by Brook Jeynes [SSW] 8 months ago.See historyBy default, the connection timeout is 15 seconds. When it comes to testing if a connection is valid or not, 15 seconds is a long time for the user to wait. You should change the connection timeout inside your connection strings to 5 seconds.
"Integrated Security=SSPI;Initial Catalog=SallyKnoxMedical;Data Source=TUNA"Figure: Bad Connection String
"Integrated Security=SSPI;Initial Catalog=SallyKnoxMedical;Data Source=TUNA;Connect Timeout=5"Figure: Good Connection String with a 5-second connection timeout
Love it
0
Agree
0
Disagree
0
No way
0
