Apache Friends Support Forum

HI, i have installed sqlsrv driver in my php ext directory and write two line of this code in my php.ini file: extension = php_sqlsrv_54_ts.dll, extension = php_pdo_sqlsrv_54_ts.dll.
I have this in my php info:

and


My code for connection:

Code: Select all

$serverName = "192.168.40.12\SQLExpress";

try

{

  $conn = new PDO("sqlsrv:server=$serverName;Database=VertiDFS", "", "");

  $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );

}

catch(Exception $e)

{

  die( print_r( $e->getMessage() ) );

}

And i see this error in my browser:
SQLSTATE[IMSSP]: This extension requires the ODBC Driver 11 for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver 11 for SQL Server ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=1637121

hackoa wrote:And i see this error in my browser:
SQLSTATE[IMSSP]: This extension requires the ODBC Driver 11 for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver 11 for SQL Server ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=1637121

I dont understand your question - the message tells you to install the ODBC Driver 11 for SQL Server (this seems to be required), did you follow that advice?

Yes i make clean install and now work fine.
thank you