We are excited to announce the hotfix release of the Microsoft Drivers for PHP for SQL Server. The SQLSRV and PDO_SQLSRV drivers have been built with PHP 7.1, 7.2, and 7.3 and tested on all supported platforms.

Notable items about this release (5.6.1) since the last production release (5.6.0) include the following:

Fixed

• Issue #937 - fixed assumptions made when calculating field or column metadata which may have resulted in application termination
• Issue #955 - modified sqlsrv config file such that it can be compiled independently of pdo_sqlsrv
• Pull Request #946 - fixed PDOStatement::getColumnMeta() to return false when something goes wrong

Limitations

• No support for inout / output params when using sql_variant type
• No support for inout / output params when formatting decimal values
• In Linux and macOS, setlocale() only takes effect if it is invoked before the first connection. Attempting to set the locale after connecting will not work
• Always Encrypted requires MS ODBC Driver 17+
  • Only Windows Certificate Store and Azure Key Vault are supported. Custom Keystores are not yet supported
  • Issue #716 - With Always Encrypted enabled, named parameters in subqueries are not supported
  • Always Encrypted limitations

Known Issues

• Connection pooling on Linux or macOS is not recommended with unixODBC < 2.3.7
• When pooling is enabled in Linux or macOS
  • unixODBC <= 2.3.4 (Linux and macOS) might not return proper diagnostic 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
• With ColumnEncryption enabled, calling stored procedures with XML parameters does not work (Issue #674)
• In SUSE 15, Azure Active Directory connections may fail if PHP is installed from packages (Issue #934)

Survey

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

Install

On Linux and macOS run the commands below:

sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv

To download Windows DLLs for PHP 7.1 or above from the PECL repository, please go to the SQLSRV or PDO_SQLSRV PECL page.