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
1or3. If not specified, the dialect defaults to3. 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
