PDO_FIREBIRD DSN

(PECL PDO_FIREBIRD >= 0.1.0)

PDO_FIREBIRD DSN — Connecting to Firebird and Interbase 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.

Examples

Example #1 PDO_FIREBIRD DSN examples

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

firebird:dbname=DATABASE.GDE

add a note User Contributed Notes PDO_FIREBIRD DSN - [2 notes]

down

jon at 3blooms dot net ¶

2 months ago


A more complete description of the PDO DSN for accessing a remote server instance of Firebird:



firebird:dbname=hostname/port:database_name



Example:



firebird:dbname=localhost/3050:C:\PKS4\Data\testdb.fdb



Of course, properly escape the backslashes in the database file path, or use a single-quoted string.

down

nelson at integrasoftware dot com dot br ¶

5 years ago


my Firebird connection example:



$str_conn = "firebird:dbname=C:\db\banco.gdb;host=localhost";

     

$dbh = new PDO($str_conn, "SYSDBA", "masterkey");

add a note