Can I use Delphi with Firebird 2.0?

Yes, you can.

There are various ways to connect and various degrees of compatibility.

IBX
This is the InterBase tab in Delphi. Basic stuff like Query work fine, even with Firebird 2.0. Probably easiest to setup and start working.

ZeosLib
http://sourceforge.net/projects/zeoslib
ZeosLib. Open Source. This is a set of database components for many SQL database engines, Firebird included. Seems to be under active development. Should be possible to use it with Free Pascal / Lazarus.

IBO
http://www.ibobjects.com
Jason Wharton's IB Objects. Commercial, but technically released as "trustware", which is some form of shareware with exclusions (see the web site for more details). Specialized for Interbase/Firebird. Lags a little behind latest Firebird development, but always manages to catch up in time. Bugs and new features are added really fast (once you request them). Also provides a set of specialized data aware controls.

ADO via ODBC
Mostly works. There are few ODBC drivers. The official one if functional, EasySoft, XTG and Gemini provide valid alternatives. There seems to be a bug with official Firebird ODBC driver and timestamp fields (only date part is set when writing).

Do you find this FAQ incorrect or incomplete? Please e-mail us what needs to be changed. To ensure quality, each change is checked by our editors (and often tested on live Firebird databases), before it enters the main FAQ database. If you desire so, the changes will be credited to your name. To learn more, visit our add content page.