How to use Delphi with Firebird?


There are various ways and various degrees of compatibility.

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 date fields (only date part is set when writing).

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.

IBO
Commercial. Specialized for Interbase/Firebird. Lags a little with 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.

FIBPlus
Commercial, claims full support even for newest Firebird features.

MDO
Mercury Data Objects, Open source, created from FreeIBComponents by Greg Deatz.

UIB
Unified Interbase, Open source

FBLib
Open source, not data aware, released under LGPL

Zeos
Open source, dual licensed under GPL and LGPL. Made for accessing Firebird via Lazarus, but also works with Delphi versions 5-11, C++Builder 5 and 6 and Kylix 2 and 3. ZeosLIB version 7 should work with Delphi 2009.

UniDAC
https://www.devart.com/unidac/download.html
Universal Data Access Components (UniDAC) is a library of components
providing direct access to databases from Delphi, C++Builder, RAD
Studio, FireMonkey, Lazarus and Free Pascal on Windows, Mac OS X, iOS,
Android, Linux and FreeBSD for both 32-bit and 64-bit platforms. Beside Firebird, UniDAC also supports Oracle, Microsoft SQL Server,
MySQL, InterBase, PostgreSQL, SQLite, DB2, Microsoft Access, Sybase
Advantage Database Server, Sybase
Adaptive Server Enterprise. A free 60-day trial version available for download.


We appreciate feedback from users of these components as we didn't have a chance to test them ourselves. Please e-mail us about your experiences and help us improve this FAQ. Thanks.


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.



All contents are copyright © 2007-2024 FirebirdFAQ.org unless otherwise stated in the text.


Links   Firebird   News   FlameRobin   Powered by FB: Home Inventory   Euchre  
Add content   About  

Categories
 Newbies
 SQL
 Installation and setup
 Backup and restore
 Performance
 Security
 Connectivity and API
 HOWTOs
 Errors and error codes
 Miscellaneous