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?
解决方案
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.