Firebird SQL Server is a database server based on Interbase 6.0. open source code. There exist Firebird distribution packages for Windows, Linux, Unix, Solaris, MacOS, 32- and 64-bit architecture. Firebird SQL Server is distributed free of charge and has no license restrictions.
Firebird Super Server - all client's connections are served by the single server process, there is common client's cache. This allows spending fewer resources for clients serving. Firebird Super Server disadvantage is absence of the ability to involve several processors for Firebird server work.
Firebird Classic Server
Firebird Classic Server creates separate server processes for each client's connection. Firebird Classic Server architecture is more reliable, as failure of one server process does not cause rejection to serve all the clients. In addition Firebird Classic allows involvement of multiprocessor architecture.
While installing Firebird you may choose between Firebird Super Server and Firebird Classic.
Firebird Embedded Server is designated for embedded databases. It consists of one dll - fbembed.dll that includes a client and a server of Firebird Super Server.
Firebird Embedded does not need to be installed on the client's work station. It is sufficient just to copy fbembed.dll and some more files to the client's computer.
Firebird Embedded disadvantage is impossibility of simultaneous connection of several clients to the single database. After successful connection Firebird Embedded blocks database file for the exclusive access.
IBProvider Professional Edition is the set of COM-components that allows working with any version of Firebird and Interbase. The components are supported by most development tools: Delphi, C++ Builder, Visual C++, .Net Framework, C#, Visual Basic, VBScript, VBA and others.
Let's write simple VBScript to check connection to Firebird. Create empty vbs file and paste the following code into it stating the right path to the database:
Dim cn, cmd, rs, i
Set cn = CreateObject ("ADODB.Connection")
cn.Open "Provider=LCPI.IBProvider.3;" & _
"Data Source=localhost:d:\temp\test.fdb; " & _
"User Id=SYSDBA;" & _
"password=masterkey;" & _
"ctype=win1251;" & _
set rs = cn.execute("select * from MON$ATTACHMENTS")
do while not rs.EOF
for i=0 to rs.Fields.Count - 1
wscript.echo rs(i).Name & "=" & rs(i).Value
Run the script in the command line to see the list of active connections to the database.
SQL> INSERT INTO cross_rate VALUES ('Dollar', 'CdnDlr', 1.3273, '11/22/93');
SQL> SELECT * from cross_rate;
FROM_CURRENCY TO_CURRENCY CONV_RATE UPDATE_DATE
============= =========== ============== ===========
Dollar CdnDlr 1.3273000 1993-11-22
There are many graphic utilities of Firebird administration other than isql.
The List of Firebird Administration Utilities
FlameRobin - Supports Firebird. Cross-platform editor of SQL, DDL, management of users.
License: open source, distributed free of charge.
IBExpert - Supports Firebird, Interbase, Yaffil. DDL and DML editors, visual query builder, code auto completion, Metadata Extractor, and many other capabilities.
License: from 179 euro.
IB/FB Development Studio
IB/FB Development Studio - Supports Firebird, Interbase. Visual database designer, embedded MERGE, scheduler, code auto completion, query analyzer, performance monitor.
License: from 149 euro.
www: IB/FB Development Studio
Blaze Top - Supports Firebird, Interbase. Developer and database administrator tool.
License: from 129 euro.
www: Blaze Top
Database Workbench - Supports several database servers including Firebird and Interbase. Stored procedures debugging, analysis of plans, embedded data mining and metadata transfer.
Licensed separately for Interbase and Firebird. 171$ for each engine (Interbase or Firebird).
www: Database Workbench
If your utility is absent in the above list, please write us at and we will add its description.