Shankh is London based consultancy started on 2011 to provide consultancy services primarily in Java. With several successful Java projects under our belt, we started exploring mobile based services towards end of 2012 which led to our first android/ios/windows-phone app which is staged for release in 2013

Some Random quotes


Innovation distinguishes between a leader and a follower. -Steve Jobs

It is not that i am smarter than others, i just persist with problems longer

Configure Squirrel to connect to Firebird Database

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…

Share

2 Responses to “Configure Squirrel to connect to Firebird Database”

  1. Firebird News » Configure Squirrel to connect to Firebird Database Says:

    […] Squirrel Sql to connect to firebird was much easier than i thought. Permalink […]

  2. Smiley Says:

    thanks for that hint – worked perfect for me ๐Ÿ˜‰
    i only needed to specify the full path to the database-file like this:

    jdbc:firebirdsql:localhost/3050:C:\path\to\your\dbfile.gdb

    (and yes, it also works with backslashes ๐Ÿ˜‰

    -smiley

Leave a Reply