Basic Operations | How to perform very basic operations from the command line.
Change password, Add user, Create database |
Tools | I have written a number of tools that I use to work with Firebird databases - a table viewer/editor, a query tool, and a data pump tool. |
Delphi | How to connect a Firebird database to a Delphi form. |
Database Explorer | How to define a BDE alias, browse tables, and add tables. |
Installation | Note that versions
1.0 and
1.5
are installed differently.
You may also have to unblock port 3050 |
Datapumps | These are programs that move data from one database to another ...
usually from one type of database to another.
In particular, from MS Access to Firebird.
|
IBConsole | A gui to browse the database structure and data |
Generators | How to add an auto increment field |
isql | Command-line interface to manage a Firebird database |
SQL Dialect | Firebird supports 2 dialects (a third is used for data migration) |
SQL | Firebird 1.5 supports a fair amount of useful SQL not supported
by Interbase 5 - This just documents some of it.
How to find the most recent record |
Template |
References
1.0.2-Release 12-16-2002 Be sure to get a released version - the beta's don't have an installer 1.5.1.4481 7-16-2004 Must unintall Interbase before installing 1.5.4 1-31-2007
www.firebirdsql.info provides a number of useful links.
sql2gdb.zip - MS Access to Firebird converter - Automatically fixes field names if they are reserved words
Borland provides a lot of great Interbase references
TECT Software Ltd contains several useful tools including an XML Export Utility and an Alias Manager.
Interbase / Firebird with Delphi - 2 about.com pages of related links, unfortunately, it opens those links in a frame with with fairly irritating adds.
Converting from Microsoft SQL Server to Firebird provides a good overview of the field types and the differences in the stored procedure languages.
ODBC Driver (alternate page) - unfortunately, I can not get this to work with Windows XP (problem with the workgroup information file (*.mdw) - google provided little help). Also, this driver does not work with the Borland Database Desktop - it connects, but I got SQL errors trying to read the table data. With MS Access 97, this driver connects, but can not read the sample Interbase table - employes.gdb - that comes with Delphi - it has a SQL error.
The INTERSOLV InterBase ODBC Driver on my Windows 98 systems works great with the Borland Database Desktop. (Installed with Delphi 5.)
Introduction to the Firebird Database - An overview for Linux users. This contains a good comparision with MySQL. Has a stored procedure and a trigger example. Has lots of reader feedback.
Author: Robert Clemenzi - clemenzi@cpcug.org