microsoft/msphpsql v4.1.6

4.1.6 Windows/Linux

on GitHub

Updated PECL release packages. Here is the list of updates:

Added

• Merged Linux and Windows code.
• Enabled connection pooling with unixODBC. To enable pooling:
  • in odbcinst.ini, add Pooling=Yes to the [ODBC] section and a positive CPTimeout value to [ODBC Driver 13 for SQL Server] section. See http://www.unixodbc.org/doc/conn_pool.html for detailed instructions.

Fixed

• Fixed issues with sqlsrv_has_rows() to prevent it from moving statement cursor (issue #37).
• Fixed sqlsrv client buffer size to only allow positive integers (issue #228).
• Fixed PECL installation errors when PHP was installed from source (issue #213).
• Fixed segmentation fault with PDOStatement::getColumnMeta() when the supplied column index is out of range (issue #224).
• Fixed the assertion error (Linux) when fetching data from a binary column using the binary encoding (issue #226).

Known Issues

• The following features are not supported with connection pooling in Linux:
  • Unicode connection strings
  • sqlsrv_server_info and sqlsrv_client_info return false
  • In certain scenarios a generic error message maybe returned instead of a specific error when pooling is disabled
  • When retrieving data from columns with a data type of XML, varchar(max), nvarchar(max), or varbinary(max) no data maybe returned or the data maybe truncated depending on the length of the data in the source table.

Install

• On Linux run the commands below:

  sudo pecl install sqlsrv-4.1.6.1
sudo pecl install pdo_sqlsrv-4.1.6.1

• On windows, download the DLLs from SQLSRV or PDO_SQLSRV PECL repository