PHP Error: This extension requires the Microsoft ODBC Driver 11 for SQL Server

Created:

2017-06-04 06:38:26 UTC

Modified:

2017-08-16 15:50:09 UTC

0

Was this article helpful?


Have more questions?

Submit a request

PHP Error: This extension requires the Microsoft ODBC Driver 11 for SQL Server

Applicable to:

  • Plesk for Windows

Symptoms

SqlSrv connection to SQL Server is not working with PHP 5.6:

Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49 [code] => -49 [2] => This extension requires the Microsoft ODBC Driver 11 for SQL Server. Access the following URL to download the ODBC Driver 11 for SQL Server for x86: http://go.microsoft.com/fwlink/?LinkId=163712 [message] => This extension requires the Microsoft ODBC Driver 11 for SQL Server. Access the following URL to download the ODBC Driver 11 for SQL Server for x86: http://go.microsoft.com/fwlink/?LinkId=163712 ) [1] => Array ( [0] => IM002 [SQLSTATE] => IM002 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) )

Cause

Missing Microsoft ODBC Driver 11 for SQL Server.

Resolution

Install the Microsoft ODBC Driver 11 for SQL Server from this page .

Have more questions? Submit a request
Please sign in to leave a comment.