4.1.8-preview Mac OS/Linux/Windows

Updated documentation for Readme regarding instructions for Linux and macOS
Updated PECL release packages. Here is the list of updates:

Added

• Connection Resiliency now supported in Windows
• Connection pooling now works in MAC

Fixed

SQLSRV and PDO_SQLSRV

• Added a workaround for a bug in unixODBC 2.3.4 when connection pooling is enabled.
• Fixed the issue in MAC such that which driver is loaded first no longer matters.

SQLSRV only

• Fixed sqlsrv_num_rows() when the client buffered result is null (issue #330).
• Fixed conversion warnings because of some const chars (issue #332).

PDO_SQLSRV only

• Improved performance by implementing a cache to store column SQL types and display sizes (issue #189).
• Fixed issue with the unsupported attribute PDO::ATTR_PERSISTENT in connection (issue #65).
• Fixed the issue when deleting something that doesn't exist (issue #336).

Known Issues

• User defined data types and SQL_VARIANT (issue #127).
• Binary column binding with emulate prepare (issue #140).
• When pooling is enabled in Linux or MAC
  • unixODBC 2.3.1 (Linux) and unixODBC 2.3.4 (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 April pulse survey:

Install

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