Edit Report a Bug

    PDO_FIREBIRD DSN

    (PECL PDO_FIREBIRD >= 0.1.0)

    PDO_FIREBIRD DSN — Connecting to Firebird databases

    Descrizione

    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.

    Esempi

    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

    add a note add a note

    User Contributed Notes 1 note

    up
    0
    jaune dot loke at gmail dot com
    4 years ago
    This is my example :

    firebird:dbname=127.0.0.1:D:/PATH/DBNAME.FDB;charset:ISO8859_1,SYSDBA,masterkey
    add a note add a note
    To Top