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 ;-)