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
来源:PHP Documentation Group · 作者与贡献记录 · CC BY 3.0。离线整理了版式、链接和媒体显示。
