Adding newer pdo_sqlsrv drivers to php stack on Azure Web app?

Question

The version of pdo_sqlsrv available by default on the current Php stack for Web app (7.4) is quite out of date.

I have tried downloading a newer version and adding it via extension= in my ini but when I look at php info it's still showing the old default version of the driver.

I'm not expert with php. Should my approach work? Should my newer version override the old version already available or do I need to do something additional to tell php which version to use?

Thanks.
Tim

Answer 1

Hello @Tim D

Please try the following to enable the pdo_sqlsrv extension for PHP 7.X on Azure Web Apps:

• Download the extension package for PHP 7 from https://github.com/microsoft/msphpsql/tree/master, unzip for following use.
• Follow the guide of https://azure.microsoft.com/en-us/documentation/articles/web-sites-php-configure/#how-to-enable-extensions-in-the-default-php-runtime to upload DLL libraries and configure in PHP runtime.
• Only for Azure Web Apps Windows (by default, Azure Web App requires X86 with nts version. Please use the libraries in msphpsql-PHP-7.0\binaries\x86 you unzip before, and use php_sqlsrv_7_nts.dll and php_pdo_sqlsrv_7_nts.dll)
• Restart the site after configuring the settings.