Microsoft SQL Server and Sybase PDO Driver (PDO_DBLIB)

Intro

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: Sqlsrv.

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.

PDO_DBLIB DSNConnecting to Microsoft SQL Server and Sybase databasesDescription The PDO_DBLIB Data Source Name (DSN) is composed of the following elements: DSN prefixThe DSN prefix is sybase: if PDO_DBLIB was linked against the Sybase ct-lib libraries, mssql: if PDO_DBLIB was linked against the Microsoft SQL Server libraries, or dblib: if PDO_DBLIB was linked against the FreeTDS libraries.hostThe hostname on which the database server resides. Defaults to 127.0.0.1.dbnameThe name of the database.charsetThe client character set.appnameThe application name (used in sysprocesses). Defaults to "PHP Generic DB-lib" or "PHP freetds".secureCurrently unused.Examples PDO_DBLIB DSN examplesThe following examples show a PDO_DBLIB DSN for connecting to Microsoft SQL Server and Sybase databases: mssql:host=localhost;dbname=testdb sybase:host=localhost;dbname=testdb dblib:host=localhost;dbname=testdb