PHP 7.0.6 Released

    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

    User Contributed Notes

    aero2sing at hotmail dot com
    3 years ago
    Be careful if you are using dblib with prepared statement, as it will crash if first execution didn't return anything.

    referring to https://bugs.php.net/bug.php?id=40639
    michal at durys dot pl
    2 years ago
    If you're using FreeTDS driver and you want to use "charset" parameter then you may have to edit freetds.conf (e.g. /etc/freetds/freetds.conf) and force connection using at least version 7.0 of the protocol.

    tds version = 7.0

    Charset parameter accepts all encodings supported by iconv (execute iconv --list to show all encodings).
    Anonymous
    3 months ago
    Instead of specifying tds version and client charset in freetds.conf, you may pass it as a parameter.
    <?php $dsn = 'dblib:version=7.0;charset=UTF-8;host=domain.example.com;dbname=example;'; ?>
    slach at 74mail dot ru
    7 years ago
    when you connect to non standart 1433 port

    for win32 use DSN like 'mssql:host=hostname,port;dbname=database'

    for FreeTDS and DB-Lib use DSN like  'mssql:host=hostname:port;dbname=database'
    ulisse at atc dot bologna dot it
    6 years ago
    on Linux ppc64 / PHP 5.1.2 / freetds-0.64 works well this way:

    <?php
    // ...
    $dbh = new PDO("dblib:host=$hostdb;dbname=$dbname", $usr, $psw);
    // ...
    ?>
    To Top