PDO_DBLIB DSN
(PECL PDO_DBLIB >= 0.9.0)
PDO_DBLIB DSN — Connecting to Microsoft SQL Server and Sybase databases
Description
The PDO_DBLIB Data Source Name (DSN) is composed of the following elements:
- DSN prefix
-
The 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.
host-
The hostname on which the database server resides.
Defaults to 127.0.0.1.
dbname-
The name of the database.
charset-
The client character set.
appname-
The application name (used in sysprocesses).
Defaults to "PHP Generic DB-lib" or "PHP freetds".
secure-
Currently unused.
Examples
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
MS SQL Server PDO Driver
MS SQL Server PDO Driver