What is Firebird SQL Server?
Firebird SQL Server is a database server based on Interbase 6.0. moot inception code. There eke out a living Firebird assignment packages for Windows, Linux, Unix, Solaris, MacOS, 32- and 64-bit architecture.
Firebird SQL Server is distributed out of charge and has no accredit restrictions.
What Firebird version to choose?
Because of today the newest construct is Firebird 2.5.
The well-founded kind is Firebird 2.1.
To institute Firebird you requirement determine Manual Firebird download SQL server that is accessible in 3 variants:
” Firebird Super Server (Firebird SS) - all clients’ connections are served before the apart server process. This allows spending fewer resources in behalf of clients serving. The set-back is dearth of the skill to entail various processors for Firebird server work.
” Firebird Model Server (Firebird CS) - creates detach server processes by reason of each patient’s connection. This Server architecture is more reliable. Firebird CS allows involvement of multiprocessor architecture.
” Firebird Embedded - specific number an eye to embedded databases. Firebird Embedded does not be in want of to be installed on the shopper’s position station. The prejudice is impossibility of coinciding influence of distinct clients to the set aside database.
While installing Firebird you may on between Firebird Wonderful Server and Firebird Classic.
” Interbase Super Server + SMP (symmetric multiprocessing) unites the advantages of two architectures - First-rate Server e Wonderful Server. Lone server process of Boland Interbase Super Server allows to reduce overheads and to bring into play common client’s nest egg; SMP technology involves the potential of multiprocessor architecture.
Although Interbase 2009 and Firebird 2.5 are based on the plebeian begetter regulations Interbase 6.0, these DBMSs are bloody different from each other on the in development stage.
Interbase Server - is a cross-platform DBMS, which supports the the greater part of known platforms: Windows, Linux, Unix, Solaris, Mac OS, etc.
Interbase has a bevy of advantages over other DBMSs:
” Updatable Views;
” Two-phase agree;
” Productive trigger logical positivism;
” Server processing of SMIDGIN fields (BLOB filters);
” Events (notifications);
” Encryption of network traffic, databases, backup files, and individual database columns.
Next abdicate Select Firebird driver
The most unified and revisionist driver is IBProvider, which is a successfully well-chosen of incident tools and undergo of all the Interbase and Firebird servers. IBProvider Masterly Version is the assault of COM-components that allows working with any adaptation of Firebird and Interbase. The components are supported before most unfolding tools: Delphi, C++ Builder, Visual C++, .Net Framework, C#, Visual Elementary, VBScript, VBA and others.
Firebird/ Interbase ODBC driver is developed by Firebird Scheme and the most well-liked model of this offering to each users is 2.0.
ODBC drivers were the Microsoft initial undertake to take measures a requirement of evidence accessing.They were the ODBC API realisation with C. ODBC API calls are sent to the explicit database API.
Technology’s usefulness - is the Cross Programme features. unixODBC condition lets ODBC drivers’ utilize consume on Unix platform.
OLE DB differs from ODBC because the opening is object-oriented API based on COM- Interfaces.
OLE DB providers may work not sole with relational database but with any other word that can be a table. It is practicable to slave away with ODBC driver with the help of OLE DB provider on the side of ODBC drivers which can be connected with ODBC figures sources. Representing connecting via OLE DB, the registration of data originator in the system is not required as in example with ODBC. All the poop is saved either in udl-files or is written in family string.
In favour of Firebird and Interbase the ODBC Driver Getaway Sequences is to hand via IBProvider - OLE DB Provider with a view Firebird and Interbase.
IBProvider Seasoned Copy - supports 16 types of Interbase and Components for ODBC Interbase 2009 SMP servers, including Interbase 2009 and Firebird 2.1, and automatically is set to mould with each of them. It independently defines the keywords, connects optimizing algorithms, set of metadata, SQL and ODBC parser, etc.
Firebird supplying tools
SSEUtil.exe is a gadget that lets you handily interact with SQL Server.There are sundry alternate utilities of Interbase and Firebird administration other than isql: Passion Robin, IBExpert, Brightness Top, IB/FB Evolution Studio, Database Workbench.