4.1.7-preview Mac OS X/Linux/Windows

We are thrilled to announce that the early technical preview for SQLSRV and PDO_SQLSRV drivers is now available. Both drivers have been built and tested on El Capitan (OS X 10.11).

Notable items about 4.1.7-preview release,

Fixed

SQLSRV and PDO_SQLSRV

• Fixed null returned when an empty string is set to an output parameter (issue #308).
• Fixed memory leaks in buffered result sets.
• Fixed clang compile errors.

SQLSRV only

• Fixed debug abort error when building the driver in debug mode with PHP 7.1.
• Fixed string truncation when binding varchar(max), nvarchar(max), varbinary(max), and xml types (issue #231).
• Fixed fatal error when fetching empty nvarchar (issue #69).
• Fixed fatal error when calling sqlsrv_fetch() with an out of bound offset for SQLSRV_SCROLL_ABSOLUTE (issue #223).

PDO_SQLSRV only

• Fixed wrong value returned when fetching varbinary value on Linux (issue #270).
• Fixed binary data not returned when the column is bound by name (issue #35).
• Fixed exception thrown on closeCursor() when the statement has not been executed (issue #267).

Survey

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

Known Issues

• User defined data types and SQL_VARIANT (issue #127).
• Binary column binding with emulate prepare (issue #140).
• Segmentation fault may result when an unsupported attribute is used for connection.

MAC only

• If loading both sqlsrv and pdo_sqlsrv, the order matters (even when dynamically). For PDO_SQLSRV scripts, load pdo_sqlsrv.so first. For SQLSRV scripts, load sqlsrv.so first.
• Connection pooling does not work.

Changed

• Version number is updated to follow semantic versioning.

Install

• On Linux and Mac run the commands below:
  sudo pecl install sqlsrv-4.1.7preview
sudo pecl install pdo_sqlsrv-4.1.7preview
• On windows, download the DLLs from SQLSRV or PDO_SQLSRV PECL repository.