云网牛站
所在位置:首页 > Linux软件 > SQL Server PHP 5.3.0驱动发布下载,支持Ubuntu 18.04

SQL Server PHP 5.3.0驱动发布下载,支持Ubuntu 18.04

2018-07-21 10:02:19作者:h4cd稿源:linux站

微软的 SQL Server PHP 5.3.0 驱动发布了,推出针对CentOS7、Debian8/9、Suse12、Ubuntu16/17/18等软件包下载,该驱动程序允许从 Linux、Windows 和 macOS 上的 PHP 7.0-7.2 应用程序访问 SQL Server、Azure SQL 数据库、Azure SQL 托管实例和 Azure SQL DW,并且实测支持最新的Ubuntu 18.04系统。

 

SQL Server PHP 5.3.0主要更新

1.Added

Added support for Azure Key Vault for Always Encrypted functionality. Always Encrypted functionality is supported on Linux and macOS through Azure Key Vault

Added support for connection resiliency on Linux and macOS (requires version 17.2 or higher of the ODBC driver)

Added support for macOS High Sierra (requires version 17 or higher of the ODBC driver)

Added support for Ubuntu 18.04 (requires version 17.2 or higher of the ODBC driver)

2.Fixed

Idle Connection Resiliency doesn't work with Column Encryption enabled connections (fixed in MS ODBC Driver 17.1)

Idle Connection Resiliency doesn't work with Connection Pooling (fixed in MS ODBC Driver 17.1)

Binding output parameters fails when the query in the stored procedure returns no data. The test case has been added to the test lab.

Always Encrypted - Retrieving a negative decimal value (edge case) as output parameter causes truncation

Always Encrypted - Cannot insert double with precision and scale (38, 38)

Always Encrypted - Fetching decimals / numerics as output parameters bound to PDO::PARAM_BOOL or PDO::PARAM_INT returns floats, not integers

Extended the buffer size for PDO::lastInsertId so that data types other than integers can be supported

Removed the limitation of binding a binary as inout param as PDO::PARAM_STR with SQLSRV_ENCODING_BINARY

Fixed the truncation problem for output params with SQL types specified as SQLSRV_SQLTYPE_DECIMAL or SQLSRV_SQLTYPE_NUMERIC

3.Limitations

No support for inout / output params when using sql_variant type

In Linux and macOS, setlocale() only takes effect if it is invoked before the first connection. Attempting to set the locale after connecting will not work

Always Encrypted requires MS ODBC Driver 17+

Only Windows Certificate Store and Azure Key Vault are supported. Custom Keystores are not supported

With Always Encrypted enabled, named parameters in subqueries are not supported

Always Encrypted limitations

4.Known Issues

Connection pooling on Linux or macOS is not recommended with unixODBC < 2.3.6

When pooling is enabled in Linux or macOS

unixODBC <= 2.3.4 (Linux and macOS) might not return proper diagnostic 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

With ColumnEncryption enabled, calling stored procedures with XML parameters does not work

 

下载地址

 

安装方法

如果是Linux或者macOS操作系统则运行以下命令安装:

sudo pecl install sqlsrv

sudo pecl install pdo_sqlsrv

 

相关主题

Ubuntu下部署SQL Server 2017(安装及使用方法,卸载方法)

精选文章
热门文章