ADO Connection Timeout problem

Using TADOConnection class to connect to SQL server 2005 db.

Having ConnectionTimeOut := 5; // seconds.

Trying to open the connection synchronously.

When the server is available and running, the connec开发者_StackOverflow中文版tion time out works fine. If the server is not available or network connection is lost, then attempting to open a connection waits for more than 5 seconds (may be 20 secs).

Is there any property or method that needs to be set to influence this behavior?

No, it's enough to set the ConnectionTimeout property

I've had the exact problem (D2009, MSSQL2005), but TADOConnection.ConnectionTimeout works fine for me (btw. the deafult value for this property is 15 seconds). Note, that the timeout dispersion is quite wide, so once you'll be timed out after 5 seconds and later on e.g. after 10 seconds, but 20 seconds is really too much for the connection attempt.

Probably you have a problem with CommandTimeout (if you are trying to execute a query with the associated ADO data set component). You need to remember, that if you set TADOConnection.ConnectionTimeout := 5 and in your data set component e.g. TADOQuery.CommandTimeout := 15, and you're trying to execute query, then you will get timeout after 20 seconds.

If you really have a problem with query execution, not only connection attempt, this post may help you ADO components CommandTimeout

TADOConnection.ConnectionTimeout - Timeout in milliseconds to connect to data source TADOConnection.CommandTimeout - Timeout in milliseconds to execute command

if you getting timeout error on trying to connect, increase value of ConnectionTimeout property, else if you getting an error on executing some query, - increase value of CommandTimeout property.