Connecting to Microsoft SQL Server and Sybase databases

MS SQL Server (PDO)
Firebird (PDO)
MS SQL Server (PDO)
PHP Manual

# 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

MS SQL Server (PDO)
Firebird (PDO)
MS SQL Server (PDO)
PHP Manual