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.