Setting a connect timeout with PDO
$DBH = new PDO( "mysql:host=$host;dbname=$dbname", $username, $password, array( PDO::ATTR_TIMEOUT => 5, // in seconds PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ));
I'm using the DBLIB driver for PDO - and that doesn't support the passing of options (throws a warning).
To get round this, you can edit the connection_timeout
setting in the FreeTDS config file which is located at /etc/freetds/freetds.conf
(on Ubuntu).