Login | Packages | Support | Bugs 

Return

Changelog for sqlsrv
Release What has changed?
4.3.0 [Added]
- Added Unicode Column name support (issue #138).
- Support for Always On Availability groups via Transparent Network IP Resolution (TNIR)
- Added support for sql_variant data type with limitation (issue #51 and issue #127)
- Support drivers on Debian Jessie (tested on Debian 8.7)
- Connection Resiliency support in Windows
- Connection pooling support for Linux and macOS
- Support for Mac(El Capitan and above)
- Azure Active Directory Authentication with ActiveDirectoryPassword and SqlPassword
[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 the assertion error (Linux) when fetching data from a binary column using the binary encoding (issue #226).
- Fixed issue output parameters bound to empty string (issue #182).
- Fixed issue with SQLSRV_ATTR_FETCHES_NUMERIC_TYPE when column return type is set on statement (issue #173).
- Fixed a memory leak in closing connection resources.
- Fixed load ordering issue in MacOS (issue #417)
- Added a workaround for a bug in unixODBC 2.3.4 when connection pooling is enabled.
- Fixed the issue with driver loading order in macOS
- Fixed null returned when an empty string is set to an output parameter (issue #308).
- Fixed incorrectly binding of unicode parameter when emulate prepare is on and the encoding is set at the statement level (issue #92).
- Fixed binary column binding when emulate prepare is on (issue #140).
- Fixed sqlsrv_num_rows() when the client buffered result is null (issue #330).
- Fixed conversion warnings because of some const chars (issue #332).
- 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).
[Limitation]
- Limited support for inout / output params when using sql_variant type
[Known Issues]
- When pooling is enabled in Linux or MAC
- unixODBC 2.3.4 or prior (Linux and 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 (https://github.com/Microsoft/msphpsql/wiki/Connection-Pooling-on-Linux-and-Mac)
4.3.0RC1 [Added]
- Added Transparent Network IP Resolution (TNIR) feature.
[Fixed]
- Fixed a memory leak in closing connection resources.
- Fixed load ordering issue in MacOS [issue #417]
[Limitation]
- Limited support for inout / output params when using sql_variant type
[Known Issues]
- When pooling is enabled in Linux or MAC
- unixODBC 2.3.4 or prior (Linux and 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 (https://github.com/Microsoft/msphpsql/wiki/Connection-Pooling-on-Linux-and-Mac)
4.2.0preview [Added]
- Added support for sql_variant data type with limitation ([issue #51] and [issue #127])
- This is a preview for Debian Jessie (tested on Debian 8.7)
[Fixed]
- Increased Test Coverage
- General bug fixes after running static analyses
[Limitation]
- Limited support for input / output params when using sql_variant
[Known Issues]
- User defined data types
- When pooling is enabled in Linux or MAC
- unixODBC 2.3.4 or prior (Linux and 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 (https://github.com/Microsoft/msphpsql/wiki/Connection-Pooling-on-Linux-and-Mac)
4.1.9preview [Added]
- Azure Active Directory Authentication with ActiveDirectoryPassword and SqlPassword
[Fixed]
- Fixed output parameter returning garbage when the parameter is initialized to a type that is different from the output type (issue #378)
[Known Issues]
- User defined data types and SQL_VARIANT ([issue #127]
- 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 (https://github.com/Microsoft/msphpsql/wiki/Connection-Pooling-on-Linux-and-Mac)
4.1.8preview [Added]
- Connection Resiliency now supported in Windows
- Connection pooling now works in MAC
[Fixed]
- Added a workaround for a bug in unixODBC 2.3.4 when connection pooling is enabled
- Fixed the issue in MAC such that the order of which drivers are loaded first no longer matters
- Fixed sqlsrv_num_rows() when the client buffered result is null (issue #330)
- Fixed compilation const char conversion warnings (issue #332)
[Known Issues]
- User defined data types and SQL_VARIANT
4.1.7preview [Added]
- The early technical preview (ETP) with basic functionalities is now available on MAC OS X. Tested on OS versions El Capitan (OS X 10.11)
[Fixed]
- Fixed null returned when an empty string is set to an output parameter (issue #308)
- Fixed memory leaks in buffered result sets
- 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 clang compile errors
- 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)
[Known Issues]
- User defined data types and SQL_VARIANT
- In MAC OS X, if loading both sqlsrv and pdo_sqlsrv, the order matters (even when dynamically). For sqlsrv scripts, load sqlsrv.so first
- Connection pooling not working in MAC OS X
4.1.6.1 [Added]
- Merged Windows and Linux source code.
- Enabled connection pooling with unixODBC in Linux.
[Fixed]
- Fixed issues with sqlsrv_has_rows() to prevent it from moving statement cursor.
- Fixed sqlsrv client buffer size to only allow positive integers.
- Fixed PECL installation errors when PHP was installed from source.
4.1.6 [Added]
- Merged Windows and Linux source code.
- Enabled connection pooling with unixODBC in Linux.
[Fixed]
- Fixed issues with sqlsrv_has_rows() to prevent it from moving statement cursor.
- Fixed sqlsrv client buffer size to only allow positive integers.
- Fixed PECL installation errors when PHP was installed from source.
4.0.8 [Added]
- Unicode Column name support.
[Fixed]
- Fixed issue with buffered cursor in PDO_SQLSRV driver when CharacterSet is UTF-8.
- Fixed issue with empty output parameters on stored procedure.
- Fixed memory leaks in buffered queries.
4.0.7 This version is for PHP 7 only.
This preview contains the SQLSRV drivers for PHP 7 (64-bit) with limitations. Upcoming release(s) will contain more functionality, bug fixes, and more.
4.0.6 This version is for PHP 7 only.
This preview contains the SQLSRV drivers for PHP 7 (64-bit) with limitations. Upcoming release(s) will contain more functionality, bug fixes, and more.
4.0.5 This version is for PHP 7 only.
This preview contains the SQLSRV drivers for PHP 7 (64-bit) with limitations. Upcoming release(s) will contain more functionality, bug fixes, and more.
4.0.4 This version is for PHP 7 only.
This preview contains the SQLSRV drivers for PHP 7 (64-bit) with limitations (see Limitations below for details). Upcoming release(s) will contain more functionality, bug fixes, and more.
3.0.1 Cumulative Update 1 for Microsoft Drivers 3.0 for PHP for SQL Server
2.0.1 Introduction into PECL repository

Return

PRIVACY POLICY | CREDITS
Copyright © 2001-2017 The PHP Group
All rights reserved.
Last updated: Thu Mar 26 06:22:20 2015 UTC
Bandwidth and hardware provided by: pair Networks