Thursday, August 17, 2006

Flamerobin as a GUI for embedded Firebird

In general you just need to have Flamerobin connect to Embedded Firebird through local protocol, my setup with Firebird 1.5.3 (Firebird 2.0 RC3 is giving me troubles!) is:

1. Pick fbembed.dll from Firebird-1.5.3.4870-0_embed_win32.zip
2. Copy it to C:\Program Files\FlameRobin (the Flamerobin installation folder, whatever it's named
3. Rename it to fbclient.dll
4. Register a new server in Flamerobin, without specifying the hostname and port (leave them blank)


5. Register a new database under that server, if you correctly left the hostname blank it will try to connect to something like "sysdba@c:\program files\employee.fdb"


5.1. Specify a password, because Flamerobin seems to want it, but remember that it will not be checked in the embedded version (privileges still exist!!)
6. You might need to copy more files from the embedded distribution to the flamerobin folder, like firebird.msg for messages, firebird.conf, ib_util.dll and the whole "intl" folder for connections with specific charsets!

Note that this allows me to keep also Firebird 2.0 RC3 installed, network connection to firebird 2 databases (new OnDiskStructure) will work, while it will fail if you try to connect as embedded (local protocol)

9 comments:

SviluppoeSviluppi said...

Following your explanation I finally can create a DB using Flamerobin and Firebird embedded.
Thank you

Luca

redstone said...

Thanks!

Justin Collum said...

Failed for me under version 2.0. Damn.

Anonymous said...
This comment has been removed by a blog administrator.
Um homem apaixonado... said...

Very, very, thank. I finally can connect and edit my DB.
Good Luck for you.

Unknown said...

Thanks for this. Why are there no good tutorials (besides yours) for connecting to Firebird embedded?

Unknown said...

Thanks a lot!

Firebird-2.1.3.18185-Win32 works fine at Vista Basic.

Anonymous said...

Firebird Embedded and FlameRobin in Linux???

vipercaraudio said...

Great post, works perfectly with Firebird-2.5.2.26540-0_Win32_embed, Thank you