PDO_DBLIB DSN
(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:
-
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.
Примеры
Пример #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