Monday, August 27, 2007

Running Firebird Embeded Database in .NET 2

I wanted to create a small application to keep track of my daily expenses. Me and my friend (we are also room mates) think that we are expending too much because we are unstructured. So I thought to give it time this Sunday.

I decided to use embedded Firebird server for easy portability.

Go to Firebird site and it says that embedding Firebird is a breeze. Me to thought so. But it might be little cumbersome as many things have changed in Firebird version 2.
I downloaded Firebird embedded package. Copied fbembed.dll and Firebird.Data.FirebirdClient to my executable directory, but every time I tried to execute
FbConnection.CreateDatabase()
I got 'Unable to load DLL "fbembed"' error.

Googling for it yielded no results except advice for copying fbembed.dll and FirebirdClient assembly to the folder where executable is.

I copied everything from embedded package and it worked. But time and again it is mentioned that every thing from package is not needed. So now again I removed the embedded stuff and started things one-by-one.

  • First fbembed.dll and FirebirdClient assembly --> It did not work.


  • Then I added all the dlls (i*.dll) from embedded package with firebird.msg --> It did not work.<.li>
  • Then I added intl folder --> It worked!!!



No I coppied these files to bin folder and added the intl folder and the dlls to my .NET Project and set their build action as content and Copy to Output Directory as Copy Always.

It is working fine and I don't have to copy it to release or debug folders.

Happy Codding ;-)

Wednesday, August 8, 2007

Why Open Source Works

I'm studying Apache OFBiz for some time, because my company Vismaad is expecting a project in which we will be using it.
I ran into some problems and had to ask for help on ofbiz mailing list. It usually takes under 40 minutes to get an answer and if problem is not severe (means only you are doing something in wrong way) you can solve it in under 2 hours.
Great!!
Many commercial help desk services cannot give you this kind of support.
Now compare it to this:
I ran into a problem with ASP.NET 2.0 AJAX website when I was using CSS Adapters for controls. I posted my problem on official ASP forum. But even after many days I'm still to get any answer.
The myth that there is no money in open source is unfounded. You only need to look at the frantic activity in mailing lists and open source software forums. All those people are not doing the work only for hobby. Yes people are cooperative and guiding, but that does not means that they don't need money or make money. Many new features and changes get thoroughly discussed in these forums and lists. So it many users have problem configuring a feature or if something important is missing you can step in or request the follow users to have it fixed in next release or at least get a patch for it.
On the other hand if you look at closed source or propriety solutions you cannot force them to make any changes, and it they have some kind of monopoly or great market share (hey! don't make any guesses) it is impossible.
So moral of the story is that open up for opensource. See, Learn and if you like it use it and give back to community by promoting it, helping other in forums and mailing lists and contributing to source code.

Long Live Open Source

Why Open Source Works

I'm studying Apache OFBiz for some time, because my company Vismaad is expecting a project in which we will be using it.
I ran into some problems and had to ask for help on ofbiz mailing list. It usually takes under 40 minutes to get an answer and if problem is not severe (means only you are doing something in wrong way) you can solve it in under 2 hours.
Great!!

Many commercial help desk services cannot give you this kind of support. But still people relay on commercial services.