5.0.0-preview Mac OS X/Linux/Windows

We are excited to announce the technical preview for SQLSRV and PDO_SQLSRV drivers support PHP 7.2 Beta 1 as well. Both drivers have been built PHP 7.2 Beta 1 and tested on all supported platforms (Mac OS X (Sierra and El Capitan), Ubuntu 16, Debian 8, CentOS 7, and Windows)

Notable items about 5.0.0-preview release,

Added

• Added support for PHP 7.2 Beta 1

Changed

• Implementation of PDO::lastInsertId($name) to return the last inserted sequence number if the sequence name is supplied to the function (lastInsertId)

Removed

• No longer support Ubuntu 15
• Supplying tablename into PDO::lastInsertId($name) no longer return the last inserted row (lastInsertId)

Limitation

• No support for inout / output params when using sql_variant type

Known Issues

• When pooling is enabled in Linux or MAC
  • unixODBC <= 2.3.4 (Linux and MAC) might not return proper diagnostics information, such as error messages, warnings and informative messages
  • due to this unixODBC bug, fetch large data (such as xml, binary) as streams as a workaround. See the examples here

Survey

Let us know how we are doing and how you use our driver by taking our pulse survey:

Install

• On Linux and Mac run the commands below:
  sudo pecl install sqlsrv-5.0.0preview
sudo pecl install pdo_sqlsrv-5.0.0preview
• Download Windows DLLs from SQLSRV or PDO_SQLSRV PECL repository.