How to connect PHP to Sqlserver via PDO

Question

I’m using the following code:

try {

    $con = new PDO("sqlsrv:Server=172.20.21.193,9090;Database=sgt","deb","123123");

    $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);  

} catch (PDOException $e) {
    die ("Erro na conexao com o banco de dados: ".$e->getMessage());
}

but is giving error when trying to connect. PDO driver is installed. Which other library or driver should I install so my application can access the database? PHP version is 5.6.9 (Linux Debian 8.1) and Sqlserver is 2008 (access will be remote).

Answer 1

I managed following the guidelines of the link: https://alephnull.uk/content/accessing-microsoft-sql-server-php-ubuntu-using-pdo-odbc-and-freetds. The line of the code went like this: $con = new PDO("dblib:host=172.20.21.193,9090;dbname=sgt", "deb", "123123");

Answer 2

Drive PDO sqlsrv does not work on Linux with PHP 5.6, in such cases use dblib.

For PHP 7.0 or higher you can use sqlsrv

Link Docker File Ubuntu 16.08 with PHP 7.0 and sqlsrv PDO https://github.com/bjverde/formDocker/blob/master/ubuntu_php7.0_mssql/ubuntu_apache_php70.Dockerfile