How do I use Firebird database?

How do I access Firebird database?

There are three basic mechanisms to get to a Firebird database. You can either use the raw C API interface, an Open Database Connectivity (ODBC) driver, or an OLE DB driver (the latter is used also for ActiveX Data Objects, ADO, access). Using the raw C API allows developers to write portable code.

What is Firebird database used for?

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.

How do I start a Firebird server?

Starting the Server As an Application Manually If the Superserver is not running, or the Classic server is not initialized, it can be started or restarted manually by selecting it from the Start ➤Programs ➤Firebird menu. Alternatively, the Guardian or the server can be started from the command prompt.

How do I create a Firebird database?

Creating a database1C:\Program Files\Firebird\Firebird_2_0\bin>isql↵Use CONNECT or CREATE DATABASE to specify a database. ... 2SQL>CREATE DATABASE 'C:\test\monkey.fdb' page_size 8192↵ CON>user 'SYSDBA' password 'masterkey';↵ ... 3SQL>SELECT * FROM RDB$monkey;↵