How to connect xampp php 7.1.27 to a MsSQL server using pdo?

Question

I'm trying to connect to a MsSQL server database with php pdo, but I get this error:

Could not find driver.

I've tried all solutions on stackoverflow none of them worked.

Installed php driver and configured php.ini. added these one by one:

extension=php_pdo_sqlsrv_71_ts.dll

extension=php_sqlsrv_71_ts.dll

extension=php_pdo_sqlsrv_71_nts.dll

and all of them at once.
Used the pdo_dblib_mssql class: https://www.php.net/manual/en/ref.pdo-dblib.php.
Used different PDO constructors:

$conn = new PDO ("dblib:host=$hostname:$port;dbname=dbname","username","pwd");

and

$conn = new PDO("sqlsrv:Server=$servername;Database=dbname", "username", "pwd");

Nothing worked, any help would be appreciated.

PHP version : 7.1.27 / MsSQL SERVER 2014.

Or check [getAvailableDrivers()](https://www.php.net/manual/en/pdo.getavailabledrivers.php). Also think about using [ODBC](https://stackoverflow.com/questions/20163776/connect-php-to-mssql-via-pdo-odbc?answertab=active#tab-top). — KIKO Software, Apr 24 '19 at 09:15
@aladdin Then, PHP driver for SQL Server is not loaded. You need to install appropriate ODBC Driver. — Zhorov, Apr 24 '19 at 09:17
https://www.microsoft.com/en-us/download/confirmation.aspx?id=50420 — Nick Maroulis, Apr 24 '19 at 09:18
I will install odbc driver now and check if it works thank you. — Creeper, Apr 24 '19 at 09:20

score 1 · Accepted Answer · answered Apr 24 '19 at 09:42

I found the answer from the comments:

odbc_connect ( "Driver={SQL Server};Server=$servername;Database=$dbname" , $username ,  $password);

1 Answers1