Release Candidate of Microsoft Drivers 4.0 for PHP for SQL Server Released!


Dear PHP Community,

Over the last few weeks our team has been working diligently towards fixing existing bugs on the Github repository and improving test coverage for the driver. Today. We are announcing the Release Candidate of the Microsoft Driver 4.0 for PHP for SQL Server. The new driver enables access to SQL Server, Azure SQL Database and Azure SQL DW from any PHP 7 application.

The major highlights of this release is bug fixes and better test coverage.

Here is a summary of issues that we fixed:

  • Added ability to connect to Microsoft ODBC Driver 13.
  • Fixed some memory leaks in data retrieval.
  • Fixed issue with error handling in bound stream parameters when send_stream_at_exec option is set to false.
  • Fixed issue with when connecting twice when Sqlsrv_errors configured to only WARNINGS.
  • Fixed issue with double and string as input-output parameters in PDO_SQLSRV driver.
  • Fixed a heap corruption in PDO_SQLSRV connection.

Future Plans

Going forward we plan on a Linux port, expand SQL 16 Feature Support (example: Always Encrypted), build verification/fundamental tests, bug fixes

Getting the Release Candidate

You can find the latest bits on our Github repository, at our existing address. We provide limited support while in preview on our Github Issues page. As always, we welcome contributions of any kind, be they Pull Requests, or Feature Enhancements. I’d like to thank everyone on behalf of the team for supporting us in our endeavors to provide you with a high-quality driver. Happy downloading!

Meet Bhagdev (meetb@microsoft.com)

MSFTlovesPHP


Comments (5)

  1. The download link appears to point to an older 32-bit only release (30 January). If you browse the repo you can find a release from 13 June that includes both 32 and 64 bit binaries:

    https://github.com/Azure/msphpsql/releases

  2. Just wishing you luck, guys. I desperately need the PHP7 driver, since the PHP7 was overwhelmingly increase web app performance.

    1. Meet Bhagdev says:

      Hello Fajri,

      Thanks 🙂 We released the production ready bits last week. Check out our announcement here: https://blogs.msdn.microsoft.com/sqlphp/2016/07/11/microsoft-drivers-4-0-for-php-for-sql-server-with-php-7-0-support-released/

  3. Mjjerabek says:

    Working with windows server 2012 r2 and ms sql 2016 and trying to get php 7.09 working with ms sql server 2016. D/Led SQLSRV040 and copied extension DLLs to PHP ext directory. Added the following to php.ini

    extension=php_odbc.dll
    extension=php_pdo_sqlsrv_7_ts_x64.dll
    extension=php_sqlsrv_7_ts_x64.dll

    I re started by rebooting the web server. Ran my info,php and did not see sqlsrv module. Any help will be appreciated.

    mjj

    1. Meet Bhagdev says:

      Can you confirm that you are editing the php.ini file used my your webserver?

Skip to main content