Query: pdo_dblib-dsn
OS: php
Section: 3
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
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)