To setup Firebird Server in a Windows machine:
- Download Firebird (either EXE version or ZIP version, but not embedded version).
- If you have downloaded EXE version, just run the setup, select Super Server type and skip to setup 4.
- If you have downloaded ZIP version, extract it to a appropriate location, go to bin folder and run install_super.bat to install the Firebird Services.
- Right now you should able to see Firebird Services at the Services Browser, where you can start or stop the server from there.
Other Post Installation actions that need to be taken:
- Open port 3050 for Firebird Server.
- The default user and password is sysdba (masterkey). To change it, use command prompt and change directory to FIREBIRD\bin, execute following command:
gsec -user sysdba -pass masterkey -mo sysdba -pw othpasswd
user is current user, pass is current password, mo is user that you want to change password while pw is the new password.
I have recommend Flamerobin as Firebird Management Tool in my earlier post, because it is free and light weighted. Recently I found another tool called EMS SQL Manager for InterBase/Firebird. It is a commercial software which has a free version. The free version does not have an expire date, but it will have a splash screen that halt the program for a while during start up. However I do believe the wait is worth because it has a bunch of features that every developer want.
To use EMS SQL Manager (I download the stand alone version, which no need for installation), you will need Firebird Access Library that within Firebird binary folder. Depend on what type of server you want to connect, for server based Firebird, you need to configure the Manager where fbclient.dll located. And for embedded Firebird, you need to locate where is fbembed.dll.
Other than Firebird, there are tools for other database such as:
- EMS SQL Manager for MySQL
- EMS SQL Manager for MSSQL
- EMS SQL Manager for Oracle
In my last post, I have recommended to use Firebird as database of standalone application. While to access or administrate the database, we can use tools like Flamerobin. However we need to do something before can use the tools:
- Download Flamerobin from its website, I recommend to download the zip version.
- Download Firebird database embedded edition (zip file as well) from its website if not yet.
- Extract Flamerobin into a directory, then extract the following files to the same directory from the firebird database zip file:
- Execute Flamerobin by double click flamerobin_ansi.exe or flamerobin_unicode.exe (which ever).
- You can see a tree directory with a localhost node. If you are running a server edition database, you straight away connect the database by adding new database. But if you are using embedded edition, you need to right click on the locahost node, click server registration info and clear off the hostname field.
Choices of database in doing a standalone application always limited to me. Some people might use MYSQL, MSSQL or even Oracle as database, but to me:
- It is not logical to use a server based database for a standalone application
- You will need to install the database in order to deploy the application, where some settings might not understandable to non technical personnel.
So all the while I am using MS Access as database for standalone application, but still you need to install Microsoft Data Access Components (MDAC) if the PC you deploy doesn’t have MS Access or Office installed.
But now I am using Firebird as database, which you don’t need to install the extra stuffs, just copy over the whole folder to finish the deployment (Literally standalone). Here are some guidelines to use Firebird in .Net:
- Go to Firebird website and download 2 things: database embeded edition (which is in zip format) and .Net FirebirdClient library (in zip format as well).
- Extract following files from the database zip file to your project folder (under bin\debug or bin\release):
- Extract FirebirdSql.Data.FirebirdClient.dll to your project folder (under bin\debug or bin\release).
- Add reference of FirebirdClient to your project, and you can start using it.
- The methods to use FirebirdClient more or less is the same as other Data class, while the connection string is: