|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
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
1.0.2-Release 12-16-2002 Be sure to get a released version - the beta's don't have an installer 220.127.116.1181 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.