array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'en', ), 'this' => array ( 0 => 'ref.pdo-dblib.php', 1 => 'MS SQL Server PDO Driver', 2 => 'Microsoft SQL Server and Sybase PDO Driver (PDO_DBLIB)', ), 'up' => array ( 0 => 'pdo.drivers.php', 1 => 'PDO Drivers', ), 'prev' => array ( 0 => 'pdo.cubrid-schema.php', 1 => 'PDO::cubrid_schema', ), 'next' => array ( 0 => 'ref.pdo-dblib.connection.php', 1 => 'PDO_DBLIB DSN', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/pdo_dblib/reference.xml', ), 'history' => array ( ), 'extra_header_links' => array ( 'rel' => 'alternate', 'href' => '/manual/en/feeds/ref.pdo-dblib.atom', 'type' => 'application/atom+xml', ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); contributors($setup); ?>

Microsoft SQL Server and Sybase PDO Driver (PDO_DBLIB)

Introduction

PDO_DBLIB is a driver that implements the PHP Data Objects (PDO) interface to enable access from PHP to Microsoft SQL Server and Sybase databases through the FreeTDS library.

This extension is not available anymore on Windows.

On Windows, you should use SqlSrv, an alternative driver for MS SQL is available from Microsoft: » http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx .

If it is not possible to use SqlSrv, you can use the PDO_ODBC driver to connect to Microsoft SQL Server and Sybase databases, as the native Windows DB-LIB is ancient, thread un-safe and no longer supported by Microsoft.

Table of Contents