©
本文档使用 PHP中文网手册 发布
PDO_SQLSRV is a driver that implements the PHP Data Objects (PDO) interface to enable access from PHP to MS SQL Server (starting with SQL Server 2005) and SQL Azure databases.
The PDO_SQLSRV extension is enabled by adding appropriate DLL file to your PHP extension directory and the corresponding entry to the php.ini file. The PDO_SQLSRV download comes 8 driver files, four of which are for PDO support. If you are running non-thread-safe PHP (PHP 5.3), use the php_pdo_sqlsrv_53_nts.dll file. (You should use a non-thread-safe version if you are using IIS as your web server). If you are running thread-safe PHP, use the php_pdo_sqlsrv_53_ts.dll file. Similarly for PHP 5.4, use the php_pdo_sqlsrv_54_nts.dll or php_pdo_sqlsrv_54_ts.dll depending on whether your PHP installation is non-thread-safe or thread-safe.
The most recent version of the driver is available for download here: » SQLSRV 3.0 download. If you need support for PHP 5.2 and/or PHP compiled with VC6, use the 2.0 release of the driver: » SQLSRV 2.0 download.
For more information about system requirements, see » SQLSRV System Requirements.
The PDO_SQLSRV extension is only compatible with PHP running on Windows. For Linux, see ODBC and » Microsoft's SQL Server ODBC Driver for Linux.
下列常量由此驱动定义,且仅在扩展编译入 PHP
或在运行时动态载入时可用。另外,使用此驱动时,仅会使用这些驱动特定的常量。使用其他驱动的驱动特定的常量可能会导致不可预见的情况。如果代码可运行于多个驱动, PDO::getAttribute()
可被用于获取
PDO_ATTR_DRIVER_NAME
属性以检查驱动。
PDO::SQLSRV_TXN_READ_UNCOMMITTED
( integer )
PDO::SQLSRV_TXN_READ_COMMITTED
( integer )
PDO::SQLSRV_TXN_REPEATABLE_READ
( integer )
PDO::SQLSRV_TXN_SNAPSHOT
( integer )
PDO::SQLSRV_TXN_SERIALIZABLE
( integer )
PDO::SQLSRV_ENCODING_BINARY
( integer )
PDO::SQLSRV_ENCODING_SYSTEM
( integer )
PDO::SQLSRV_ENCODING_UTF8
( integer )
PDO::SQLSRV_ENCODING_DEFAULT
( integer )
PDO::SQLSRV_ATTR_QUERY_TIMEOUT
( integer )
PDO::SQLSRV_ATTR_DIRECT_QUERY
( integer )
[#1] Peter [2015-04-17 18:04:41]
SQLSRV 3.2 is now available from Microsoft that supports PHP 5.6
http://www.microsoft.com/en-us/download/details.aspx?id=20098
[#2] John P [2014-12-16 17:29:59]
As of 12/12/2014, Microsoft has officially released Version 3.1.
Support for 5.5 has 4 drivers
php_pdo_sqlsrv_55_nts.dll
php_pdo_sqlsrv_55_ts.dll
php_sqlsrv_55_nts.dll
php_sqlsrv_55_ts.dll
Note: Version 3.1 now supports PHP 5.5 and requires Microsoft ODBC Driver 11 (or higher)
You can downlod the new driver from
http://www.microsoft.com/en-us/download/details.aspx?id=20098
[#3] Anonymous [2014-07-15 13:03:52]
Note that Microsoft has not been updating this driver for some time. There are unofficial builds for PHP 5.5 based on patches against the source code head revision (from codeplex), and unconfirmed rumors that getting the source to build with PHP 5.6 is difficult.
Official versions have been released only for PHP 5.2, 5.3 and 5.4.
These problems probably apply to both the PDO driver (pdo_sqlsrv) and the non-PDO driver (sqlsrv extension), since they seem to be built and released together.