Setting a connect timeout with PDO Setting a connect timeout with PDO postgresql postgresql

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).