Interbase connection strings

SIBPROvider Interbase OLE DB Provider

  • Standard

    provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb;
    user id
    =SYSDBA;Password=masterkey;
  • Version 2.x

    Provider=SIBPROvider.2;Data Source=localhost:c:\databases\gdbs\mygdb.gdb;
    Persist Security Info
    =False;
  • Specifying character set

    provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb;
    user id
    =SYSDBA;Password=masterkey;character set=ISO8859_1;
  • Specifying role

    provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb;
    user id
    =SYSDBA;Password=masterkey;role=DIGITADORES;
Problems connecting?
Get answer in the Interbase Q & A forum

.NET Framework Data Provider for OLE DB

  • Use an OLE DB provider from .NET

    Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

    See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.

Intersolv InterBase ODBC Driver

  • Local computer

    Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=localhost;
    Database
    =localhost:C:\mydatabase.gdb;Uid=myUsername;Pwd=myPassword;
  • Remote Computer

    Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=myServerAddress;
    Database
    =ComputerName:C:\mydatabase.gdb;Uid=myUsername;Pwd=myPassword;

IBPhoenix Open Source ODBC Driver (aka Firebird ODBC driver)

  • 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

  • Using alias (aliases.conf) for remote connections

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

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

    (the file extension for the data file could also be .ib)

  • Remote connection to Interbase

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

    The default TCP/IP port 3050 will be used.

  • Specifying TCP/IP port number (.gdb)

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

    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.gdb;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.

  • 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.gdb;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.

  • Read Only connection (Interbase)

    This one is for Interbase file with the .gdb extension.

    DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;
    DBNAME
    =C:\database\myData.gdb;READONLY=YES;
  • Return with error on lock conflict (Interbase)

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

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

Easysoft ODBC

  • Local computer

    Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:C:\mydatabase.gdb;
    Uid
    =myUsername;Pwd=myPassword;
  • Remote Computer

    Driver={Easysoft IB6 ODBC};Server=myServerAddress;
    Database
    =ComputerName:C:\mydatabase.gdb;Uid=myUsername;Pwd=myPassword;

.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.

Q&Aask question »

Articlesread all »

Connect

Articlesread all »

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.