PDO_FIREBIRD DSN

    (PECL PDO_FIREBIRD >= 0.1.0)

    PDO_FIREBIRD DSN — Connecting to Firebird databases

    Description

    The PDO_FIREBIRD Data Source Name (DSN) is composed of the following elements:

    DSN prefix

    The DSN prefix is firebird:.

    dbname

    The name of the database.

    charset

    The character set.

    role

    The SQL role name.

    dialect

    The dialect of the database; either 1 or 3. If not specified, the dialect defaults to 3. Available as of PHP 7.4.0.

    Examples

    Example #1 PDO_FIREBIRD DSN example with path

    The following example shows a PDO_FIREBIRD DSN for connecting to Firebird databases: 

    firebird:dbname=/path/to/DATABASE.FDB

    Example #2 PDO_FIREBIRD DSN example with port and path

    The following example shows a PDO_FIREBIRD DSN for connecting to a Firebird database using hostname port and path: 

    firebird:dbname=hostname/port:/path/to/DATABASE.FDB

    Example #3 PDO_FIREBIRD DSN example with localhost and path to employee.fdb on Debian system

    The following example shows a PDO_FIREBIRD DSN for connecting to a Firebird database employee.fdb using localhost: 

    firebird:dbname=localhost:/var/lib/firebird/2.5/data/employee.fdb

    Example #4 PDO_FIREBIRD DSN to connect to a dialect 1 database

    The following example shows a PDO_FIREBIRD DSN for connecting to a Firebird database test.fdb which has been created using dialect 1. This is only supported as of PHP 7.4.0. 

    firebird:dbname=localhost:/var/lib/firebird/2.5/data/test.fdb;charset=utf-8;dialect=1

    Improve This Page

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top