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.