Access a firebird embedded database using squirrel

Question

I am using an application that apparently uses Firebird as database.

I believe this because in the app directory, I found the files firebird.conf and firebird.msg. The data file is called database.cdb.

I'm trying to access this file directly, without going through the application. Can anyone suggest me a good way to do this?

I'm trying to use the SQuirrel SQL, but so far without success (I'm not able to build a proper connection string).

I'm using a windows SO. I checked services/process and wasn't able to find anyone that suggests that Firebird is running.

Answer 1

You will need to install a Firebird Server and then use a Firebird admin tool like Flame Robin to access the database. You need to make sure that the application is not running, because most likely it is using Firebird embedded (which means that database server is running as part of the application, and the database file will then be opened exclusively by the application).

Answer 2

It looks like you should be able to use the Jaybird JDBC provider.

Answer 3

Install Firebird server as suggested and make sure it is started.

Then you could try EMS SQL Manager for InterBase/Firebird Freeware that has a nice GUI and it can list/browse/edit all the tables/procedure/triggers/etc that the database may contain.

In EMS, first register a host (localhost) - push the "Detect Automatically" button to detect the Firebird server previously installed. For the connection settings, the default username is SYSDBA, password masterkey for the Firebird server.

Next step, register the database by providing the path to it.