[FIXED] How to recompile PHP with either NTS or TS?

Issue

I am trying to get SQLSRV PDO to work with PHP. I run PHP -v and get the following error

Warning: PHP Startup: pdo_sqlsrv: Unable to initialize module

Module compiled with build ID=API20180718,NTS,VC15

PHP compiled with build ID=API20180718,TS,VC15

These options need to match

in Unknown on line 0

I was getting a different error where the dates in the IDs didn't match, but I have fixed that by getting the current version of PHP (7.2) and putting that in place. It wasn't installed it was a zipped archive that I extracted into the path. Then had to copy the correct php.ini file in as well.

Now I get the above error when running php -v instead of seeing the php version information displayed.

I am trying to install CakePHP. I have gotten to the point where I'm installing composer. I get this same error when trying to install composer.

All of this is on my web server: Windows Server 2012 R2 Standard x64

How do I fix this so that I can install Composer?

Solution

As you are on Windows, you need the TS (Thread Safe) version of the dll and not the NTS (Not Thread Safe) version.

Make sure that the php.ini file is loading only the TS extension.

Answered By - RiggsFolly