Added Firebird support; my notes for the process:
- Download & install FlameRobin
- Make sure the embedded FIrebird dlls (fbembed.dll etc) are in your system directory
or
in your FlameRobin directory - and copy fbembed.dll to fbclient.dll as Flamerobin looks for that (based on memory, did this a long time ago)
- Start flamerobin, server, register server
display name: embedded
hostname: leave blank
port number: leave blank
- Under that embedded server, create a new database healthdb.fdb
in your project directory, user SYSDBA, password masterkey, charset UTF8, role RDB$ADMIN, page size 16384, sql dialect 3
- connect to the db
- rightclick, execute sql query; copy & paste from healthdb_firebird.sql, omitting the create datbase part, and click the play icon (execute statements)
- the statements should run ok, in the statistics tab you should see blue text (not red) ending in "script execution finished". Note the GRANT statements that give the PUBLIC role (=the default role for any connection with any user) all rights to the table
- commit the statements by clicking the checkmark icon (commit transaction, F5)
- disconnect from the database to avoid keeping the db locked.