Preview of Microsoft Drivers 4.0.4 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 early technical preview of the Microsoft Driver 4.0.4 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:

  • Fixed retrieving stream data and metadata.
  • Fixed issue with bind stream parameters.
  • Fixed issue with retrieval in error case when trying to retrieve a non-streamble data type with SQLSRV_SQLTYPE_STREAM option
  • Fixed issue with querying after another query with empty array of parameters.
  • Fixed issue with retrieving integers as output parameter in SQLSRV 64-bit.
  • Fixed issue scrollable statement option in SQLSRV_PDO 64-bit.
  • Improved handling closed connection and statement resources.
  • Fixed issue with binding bit parameter.
  • Fix for The $driver_options (for specifying encoding) is included in PDOStatement::bindParam is included in PHP 7.0.6 release.

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 Preview Refresh

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