Firebird connection strings

Firebird ADO.NET Data Provider

• Standard

  User=SYSDBA;Password=masterkey;Database=SampleDatabase.fdb;DataSource=localhost;
Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;
MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;
  • Firebird

• Using the Firebird embedded server

  User=SYSDBA;Password=masterkey;Database=SampleDatabase.fdb;DataSource=localhost;
Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;
MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=1;

  It's the key/value ServerType=1; that tells the driver it's in embedded mode.

  • Firebird

• Disable pooling

  User=SYSDBA;Password=masterkey;Database=SampleDatabase.fdb;DataSource=localhost;
Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=false;
Packet Size=8192;ServerType=0;
  • Firebird

IBPhoenix Open Source ODBC Driver (aka Firebird ODBC driver)

• Local database Firebird

  DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=C:\database\myData.fdb;
  • Firebird

• Remote connection to Firebird

  DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=MyServer:C:\database\myData.fdb;

  The default TCP/IP port 3050 will be used.

  • Firebird

• Specifying TCP/IP port number

  DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=MyServer/3051:C:\database\myData.fdb;
  • Firebird

• Using alias (aliases.conf)

  DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;DBNAME=aliasname;

  Example record in aliases.conf, aliasname = C:\database\myData.fdb

  • Firebird
  • Interbase

• Using alias (aliases.conf) for remote connections

  DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=MyServer/3051:aliasname;
  • Firebird
  • Interbase

• Specifying dialect Firebird

  SQL dialects were introduced in InterBase 6.0, to support a number of new SQL features including delimited identifiers.

  DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=C:\database\myData.fdb;DIALECT=3;

  DIALECT=1 - Parser processes as it did in InterBase V5.

  DIALECT=2 - Transitional flagger. InterBaseV6, and Firebird flags ambiguous SQL constructs and issues an error or warning message.

  DIALECT=3 - Parser processes anything delimited by single quotes as string constants and any thing delimited by double quotes as SQL delimited identifiers.

  • Firebird

• Autoquote identifiers

  The driver will quote (") your table names in SQL statements automatically.

  DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=C:\database\myData.fdb;AUTOQUOTED=YES;

  'SELECT A.Field FROM Table A' will be transformed into 'SELECT "A.Field" FROM "Table" A'

  Be aware that upper case SQL keywords must be used, ie SELECT and FROM etc, not Select and From, else transformation will fail.

  • Firebird

• Read Only connection (Firebird)

  This one is for Firebird file with the .fdb extension.

  DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=C:\database\myData.fdb;READONLY=YES;
  • Firebird

• Return with error on lock conflict (Firebird)

  DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=C:\database\myData.fdb;NOWAIT=YES;

  Normally the transaction will wait if it encounters a lock conflict. This connection string will cause an error instead.

  • Firebird

• Wait timeout for error on lock conflict (Firebird)

  DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=C:\database\myData.gdb;LockTimeoutWaitTransactions=4;

  Normally the transaction will wait if it encounters a lock conflict. This connection string will raise an error after 4 seconds.

  • Firebird

.NET Framework Data Provider for ODBC

• Use an ODBC driver from .NET

  Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;

  See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.