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; -
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; -
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;
↯ Problems connecting?
Get answer in the Firebird Q & A forum
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; -
-
Remote connection to Firebird
DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=MyServer:C:\database\myData.fdb; -
Specifying TCP/IP port number
DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=MyServer/3051:C:\database\myData.fdb; -
Using alias (aliases.conf)
DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;DBNAME=aliasname;
-
Using alias (aliases.conf) for remote connections
DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=MyServer/3051:aliasname; -
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; -
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; -
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; -
Return with error on lock conflict (Firebird)
DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=C:\database\myData.fdb;NOWAIT=YES; -
Wait timeout for error on lock conflict (Firebird)
DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
DBNAME=C:\database\myData.gdb;LockTimeoutWaitTransactions=4;
.NET Framework Data Provider for ODBC
-
Use an ODBC driver from .NET
Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;
Connect
Articlesread all »
- Formating Rules for Connection Strings
- Connection Strings Explained
- Store Connection String in Web.config
- Connection Pooling
- The Provider Keyword, ProgID, Versioning and COM CLSID Explained
- SQL Server Data Types Reference
- Network Protocol for SQL Server Connection
- All SQL Server SqlConnection Properties
- When to use the SQL Native Client
- Open a password-protected Excel workbook
Didn't find your connection string?
Start over from the connection string reference index - or try a search!
In the Q&A forums you can ask your own question and let somebody help you.
The knowledge articles contains solutions and guides.