(PECL PDO_DBLIB >= 0.9.0)
PDO_DBLIB DSN — Connecting to Microsoft SQL Server and Sybase databases
The PDO_DBLIB Data Source Name (DSN) is composed of the following elements:
The DSN prefix is
sybase: if PDO_DBLIB was linked against the FreeTDS libraries,
mssql: if PDO_DBLIB was linked against the Microsoft SQL Server libraries, or
dblib: if linked against any other variety of DB-lib.
The hostname on which the database server resides. Defaults to 127.0.0.1.
The name of the database.
The client character set.
The application name (used in sysprocesses). Defaults to "PHP Generic DB-lib" or "PHP freetds".
Example #1 PDO_DBLIB DSN examples
The 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