apachepdoPHPsql serverwindows
I am trying to add the PDO drivers so I can work with MSSQL
I get error 'could not find driver'. In my php.ini I have tried adding
extension=php_pdo_sqlsrv_53_ts.dll
extension=php_pdo_sqlsrv_53_ts_vc9.dll
extension=php_pdo_sqlsrv_53_ts_vc6.dll
But my phpinfo() shows no sqlsrv in PDO, only mysql and sqlite
I had to actually install the extension, and this is how i did on Ubuntu 16 running PHP 7.1:
sudo apt install php7.1-sqlite3
mssql is the old way of doing it, sqlsrv should be more appropriate! In fact the extension is called (extension=php_pdo_sqlsrv_53_ts_vc9.dll) as well ;)
try {
$DBH = new PDO("sqlsrv:Server=xxxx;Database=xxxx", 'xxxx', 'xxxx');
} catch (PDOException $e) {
echo $e->getMessage();
}
Hope this helps!
Source : http://php.net/manual/fr/ref.pdo-sqlsrv.connection.php
Best Answer
I finally found my own answer...
My php.ini file that was loaded was not from
but from