PDO_DBLIB DSN - Connecting to Microsoft SQL Server and Sybase databases
Вернуться к: MS SQL Server (PDO)
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, ordblib: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
Вернуться к: MS SQL Server (PDO)