Where I can download compatible versions of PHP and MS SQL Server drivers for IIS Version 10.0.19041.1 running on Windows 10 Version 21H2 (Build 19044,2486)

Question

Hi everybody

New to the forum. Could use some help.

I believe I know the cause of this problem.

I just need to know where I can download compatible versions of PHP and MS SQL Server drivers for

IIS Version 10.0.19041.1 running on Windows 10 Version 21H2 (Build 19044,2486)

I have spent almost a week trying to sort this out to no avail.

Image attached showing modules enabled.

Below is what's written to the log file.

I have never had a problem with this using IIS6 & IIS7. It was pretty straight forward.

It seems to have become complicated.

Thanks in advance.

Ray

[14-Jan-2023 09:48:55 UTC] PHP Warning: PHP Startup: pdo_sqlsrv:

Unable to initialize module

Module compiled with module API=20210902

PHP compiled with module API=20220829

These options need to match

in Unknown on line 0

[14-Jan-2023 09:48:55 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_pdo_sqlsrv_81_nts.dll' (tried: C:\php821Win32vs16x64\ext\php_pdo_sqlsrv_81_nts.dll (The specified module could not be found), C:\php821Win32vs16x64\ext\php_php_pdo_sqlsrv_81_nts.dll.dll (The specified module could not be found)) in Unknown on line 0

[14-Jan-2023 09:48:55 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'php_sqlsrv_81_nts.dll' (tried: C:\php821Win32vs16x64\ext\php_sqlsrv_81_nts.dll (The specified module could not be found), C:\php821Win32vs16x64\ext\php_php_sqlsrv_81_nts.dll.dll (The specified module could not be found)) in Unknown on line 0

[14-Jan-2023 09:48:55 UTC] PHP Warning: PHP Startup: sqlsrv: Unable to initialize module

Module compiled with module API=20210902

PHP compiled with module API=20220829

These options need to match

Answer 1

Today only PHP 8.x are actively supported by the PHP community. But Microsoft no longer supports PHP 8.x on Windows/IIS, as announced a few years ago. As a result, you'd better switch to Linux to host your PHP 8.x web apps. The same applies to Azure App Service.

Answer 2

Thanks for that. I will give look for earlier versions. Whatever happened to backward compatability?