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.
The constants below are defined by
this driver, and will only be available when the extension has been either
compiled into PHP or dynamically loaded at runtime. In addition, these
driver-specific constants should only be used if you are using this driver.
Using driver-specific attributes with another driver may result in
unexpected behaviour. PDO::getAttribute() may be used to
obtain the PDO_ATTR_DRIVER_NAME
attribute to check the
driver, if your code can run against multiple drivers.
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)