This extension requires the Microsoft ODBC Driver 13 for SQL Server to communicate with SQL Server

0
votes

I'm trying to connect mssql database with php 7 and ubuntu 16.04. I installed odbc driver and check it with sample_c_linux file its working but when I'm executing my code its giving this error.

[PDOException] SQLSTATE[IMSSP]: This extension requires the Microsoft ODBC Driver 13 for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver 13 for SQL Server for x86: http://go.microsoft.com/fwlink/?LinkId=163712

$db = DB::connection('sqlsrv');
$sql = "sp_EntityFullList";
$procedure = $db->getPdo()->exec( $sql );
1
phpsql-serverlaravelubuntuubuntu-16.04
microsoft.com/en-us/download/details.aspx?id=50420 - Gabriel Heming
@GabrielHeming I already install from this link with looking instructions. But it doesn't worked. - Murat Kaya
It's so weird. sqlsrv is a bit new to Linux, but still weird. May you change from sqlsrv to FreeTDS or it's not an option? - Gabriel Heming
@GabrielHeming actually sqlsrv its name of environment which I gave in .env file. also I can connect tsql -S serveradress -U sa - Murat Kaya

1 Answers

0
votes

Still you need to install ODBC 11 driver.

Ref: https://www.microsoft.com/en-us/download/details.aspx?id=36434