Database Server Error: Timeout Expired

streatley · Post by **streatley** » Fri 20 Oct 2006 12:48

Connecting to MS SQL Server via a Delphi application using your dBExpress components we sometimes get the following error:

Database Server Error: Timeout Expired

This has never occured on a local copy of SQL, very infrequently over the LAN and more commonly via VPN - hence I assume it's network bandwidth that the problem. The message is not 'terminal' as OK'ing the dialog allows the app to continue (the connection seems to be re-established), however is there anyway to 'avoid' this message occuring where there is a valid delay due to network bandwidth, for example by increasing the timeout?

Regards
Anton

Jackson · Post by **Jackson** » Mon 23 Oct 2006 11:32

Use 'Connection Timeout' parameter (eConnTimeOut) to specify the time interval, in seconds,
that must expire before an attempt to make a connection is considered unsuccessful.