Search code examples
phpsql-serverdllwampserver

The 'php_sqlsrv_56_ts.dll' extension file exists but there is no 'extension=php_sqlsrv_56_ts.dll' line in php.ini

I am trying to use sql-server with php . I downloaded 64 bit php_pdo_sqlsrv_56_ts.dll and php_sqlsrv_56_ts.dll from this unofficial site. I extracted the dll files to D:\wamp64\bin\php\php5.6.31\ext. In php.ini I have added the following lines and restarted the WAMP:

[PHP_SQLSRV]
extension=php_sqlsrv_56_ts.dll
[PHP_PDO_SQLSRV]
extension=php_pdo_sqlsrv_56_ts.dll

in WAMP>php>extensions , it shows me this:

enter image description here

on clicking those extensions, php console shows the error The 'php_sqlsrv_56_ts.dll' extension file exists but there is no 'extension=php_sqlsrv_56_ts.dll' line in php.ini. .

I have no idea where the problem is, i found out same question here but that was version (32/64) issue which is also not my case as i have downloaded 64 bit extensions already.

Any suggestions would be extremely helpful.

Solution

  • Apparently, there are two php.ini files, one in wamp>bin>PHP folder and the other is in Apache folder which is also available from in wamp tray icon. I updated the file in php folder, and on checking ,the php.ini in wamp (tray icon) wasn't updated. On updation of that file, the issue was resolved.