vicker313 tech blog

June 13, 2009

Use Firebird as standalone application database

Filed under: .Net, Firebird — Tags: , , — vicker313 @ 8:33 am

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:

  1. It is not logical to use a server based database for a standalone application
  2. 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:

  1. 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).
  2. Extract following files from the database zip file to your project folder (under bin\debug or bin\release):
    1. fbembed.dll
    2. firebird.conf
    3. firebird.msg
    4. icudt30.dll
    5. icuin30.dll
    6. icuuc30.dll
  3. Extract FirebirdSql.Data.FirebirdClient.dll to your project folder (under bin\debug or bin\release).
  4. Add reference of FirebirdClient to your project, and you can start using it.
  5. The methods to use FirebirdClient more or less is the same as other Data class, while the connection string is:
    servertype=1;user=<admin>;password=<password>;dialect=3;database=<database location>
Advertisements

1 Comment »

  1. […] to access Firebird database In my last post, I have recommended to use Firebird as database of standalone application. While to access or […]

    Pingback by Tools to access Firebird database « vicker313 tech blog — June 20, 2009 @ 12:44 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: