Interbase/Firebird Connection

About Interbase

InterBase is a relational database management system (RDBMS) currently developed and marketed by Embarcadero Technologies. InterBase is distinguished from other DBMSs by its small footprint, close to zero administration requirements, and multi-generational architecture. InterBase runs on the Linux, Microsoft Windows, Mac OS X and Solaris operating systems.

About Firebird

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981.

Connection

Comments

User fields

Creating Interbase/Firebird connection

• In the Name Text Box type in a new name for the connection you are about to create
• Type in the database name
• Fill in Username/Password for the database you wish to connect to
• Click Test Connection to ensure the details you have provided are correct
• Click OK to close the connection properties window

Connection Strings

Connection string is a local or remote path to the database being attached.

For TCP protocol:

<host> [ / ] : <file path to database or alias>

For local connections as simple as:

<file path to database or alias>

If host name is omitted, local connection is implied. Depending on settings, platform and Firebird version, it could be performed via either the embedded engine or XNET (shared memory) protocol or TCP localhost loopback.

Connect via TCP using database name:

192.168.0.11:/db/mydb.fdb
192.168.0.11:C:\db\mydb.fdb
myserver:C:\db\mydb.fdb
localhost:/db/mydb.fdb

Connect via TCP using database alias:

192.168.0.11:mydb
myserver:mydb
localhost:mydb

Connect via TCP using non-default port 3051:

192.168.0.11/3051:C:\db\mydb.fdb
192.168.0.11/3051:mydb
myserver/3051:/db/mydb.fdb
localhost/3051:/db/mydb.fdb
myserver/3051:mydb
localhost/3051:mydb

Connect via TCP using non-default service name:

192.168.0.11/fb_db:C:\db\mydb.fdb
192.168.0.11/fb_db:mydb
localhost/fb_db:/db/mydb.fdb
myserver/fb_db:/db/mydb.fdb
myserver/fb_db:mydb
localhost/fb_db:mydb

Local connection:

C:\db\mydb.fdb
mydb

Notes

1. The InterBase connection dynamically loads InterBase client DLL (GDS32.DLL or FBClient.dll for Firebird)
2. Our software installs InterBase client DLL
3. 32 bit version uses 32 bit client DLL and 64 bit uses 64 bit client DLL

Used by

1. Interbase/Firebird Reader
2. Interbase/Firebird Writer
3. Database Loop Action
4. Sql Script Action
5. Sql Data Check Action
6. Check Connection Action
7. SQL To Text Dynamic Action
8. SQL To XML Dynamic Action
9. SQL To Insert Dynamic Action
10. SQL To Excel Dynamic Action
11. SQL To QVD Dynamic Action
12. SQL To QVX Dynamic Action
13. Select Value Action
14. SQL Record to Variables Action
15. SQL to Variables Action