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