Link to home
Start Free TrialLog in
Avatar of chrislindsay
chrislindsayFlag for United Kingdom of Great Britain and Northern Ireland

asked on

PHP 7 issue seeing runtime MS SQL driver in PHP info page

Hi Experts,

I am experiencing problems installing a MS SQL driver for PHP 7.1.1 on Win Server 2012.

Operating System is Server 2012 Standard
The web service is IIS 8  Server API  CGI/FastCGI  
The installed version of PHP is 7.1.1
The 64 bit sql driver I have placed in the ext folder are php_sqlsrv_7_nts_x64.dll and php_sqlsrv_7_ts_x64.dll
Updated the php.ini file
I can't see either of the drivers in the PHP INFO file when I refresh the page
I have installed the ODBC driver 11 and 13 on the server.
I have read on a forum (unconfirmed) that PHP 7.1 will not work with MSSQL drivers on Windows 2012 server..

Any help would be appreciated.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chrislindsay

ASKER

Hi Ray, Can you use PDO with my windows server configuration or is this for Linux?
Thanks
Disapointing...that I cant use the MS drivers with PHP 7.0
I think this might be a good path forward: http://php.net/manual/en/ref.pdo-sqlsrv.php
Avatar of Dave Baldwin
I wrote an article about PHP and MS SQL Server.  I think it's still good for PHP 7.  At least the code stills works here.
https://www.experts-exchange.com/articles/28391/PHP-and-Microsoft-SQL-Server.html