I was looking for some tutorial about configuring Squirrel SQL (http://squirrel-sql.sourceforge.net/) to connect to firebird database and unfortunately i couldn’t find one . So when i finally managed to connect, i thought of publishing the steps in my log so that it could be useful to some one else.

Configuring Squirrel Sql to connect to firebird was much easier than i thought. You need to go to firebird website and  look for JCA-JDBC Driver downloads. At the time of writing this blog, the latest release was 2.1.6 (http://prdownloads.sourceforge.net/firebird/Jaybird-2.1.6JDK_1.6.zip?download). Download it and unzip it. There will be a jar file called Jaybird-2.1.6-full.jar. Copy this file and save it in your Squirrel lib directory (It will be something like C:/Program Files/Squirrel SQL/ lib).

Now start Squirrel and you will see the jaybird driver listed in the drivers window (with a tick sign).  Now click on the menu and click add. In the Database driver section put Jaybird Driver and provide the database url in the format jdbc:firebirdsql:localhost/3050:/firebird/test.gdb Now give your username and password . Hooray !!! you are finally connected to firebird database…