How to setup connection to ms sql via PDO class?

Question

PHP

I do this $DBH = new PDO("mssql:host=localhost;dbname=health", $user, $pass);
in response I get only
Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in D:\Projects\ZInfo\ZInfo-App-IsraelDieta\htdocs\site.ru\index2.php:5 ​​Stack trace: #0 D:\Projects\ZInfo\ZInfo-App-IsraelDieta\htdocs\site.ru\index2.php(5): PDO->__construct('mssql:host=SIRI...', '-----', '------...') #1 {main} thrown in D:\Projects\ZInfo\ZInfo-App-IsraelDieta\htdocs\site.ru\index2.php on line 5

Answer 1

php.net/manual/en/ref.pdo-sqlsrv.php

Answer 2

If you are on Windows (judging by the paths), then you need to install SQL Server Native Client x64 or x86 , depending on the platform. Then install the sqlsrv driver itself (do not forget to read the README, where it says which version of php which extension to connect to).
Then use the following as your DSN:

$dsn = 'sqlsrv:server=your-sqlserver-host.com;Database=db_name';
$pdo = new PDO($dsn, $username, $password);

Answer 3