I had been attempting to use Firebird embedded server with Microsoft Visual C# 2010. so here's what I done till now:

  1. Downloaded Firebird .Internet Data Provider (Firebird Client v2.5.2).

  2. Downloaded Firebird Embedded server (Firebird Embedded Server v2.5.0).

  3. Added a mention of the FirebirdSql.Data.FirebirdClient.dll to my project.

  4. Removed and Replicated fbembed.dll file to my application's directory.

  5. Added my FDB file "TEST.FDB" to my application's directory.

  6. Added "using FirebirdSql.Data.FirebirdClient" statement.

To date so great (I guess)...

Now after i attempt to connect with my FDB file while using following code:

    FbConnection con = new FbConnection("User=SYSDBA;" + "Password=masterkey;" + "Database=TEST.FDB;" + "DataSource=127.0.0.1;" + "Port=3050;" + "Dialect=3;" + "Charset=UTF8;");
    try  {
             con.Open();
         }
    catch (Exception ex) 
         {
            MessageBox.Show(ex.ToString());
         }

I usually obtain the messagebox meaning the code isn't hooking up to my DB file correctly. shall we be held doing a problem? I am really still noob with C# and that i have no clue how to get this done or repair it and that i hope someone can help me with this particular.

thanks :)

EDIT: here's what I recieve within the exception:

FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Not able to accomplish network request to host "127...1". ---> Not able to accomplish network request to host "127...1". at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create() at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut() at FirebirdSql.Data.FirebirdClient.FbConnection.Open() at fbTestApp.Form1.button1_Click(Object sender, EventArgs e) in C:Documents and SettingsermacMy DocumentsVisual Studio 2010ProjectsfbTestAppfbTestAppForm1.cs:line 25

I finally I discovered the answer after 6 hrs of labor :)

the majority of solutions on the internet are generally wrong approximately old. these state that I only have to include fbembed.dll file to my project..

after a little research I made. I discovered which i should also add firebird.monosodium glutamate, firebird.conf, icudt30.dll, icuin30.dll, icuuc30.dll and ib_util.dll to my project files and also to the output folder..

important notice: never use compact .Internet data provider. simply because they managed to get for Normal and super firebird servers only. it will not use embedded servers.

With Firebird 2.5 embedded, I copy all of this files towards the application directory :

aliases.conf (optional)
fbembed.dll
firebird.conf
firebird.msg
ib_util.dll
icudt30.dll
icuin30.dll
icuuc30.dll
Microsoft.VC80.CRT.manifest  : -- Not sure if this 3 files are necessary
msvcp80.dll                  : -- but i copy them :)
msvcr80.dll                  : -- see http://www.firebirdnews.org/?p=2248
intl\fbintl.conf   : Without those files you can't use
intl\fbintl.dll    : all charset and collations
udf\*  : if you want to use pre-build UDF

Within the connection string, I specify the server is embedded wih serverType=1:

User=SYSDBA;Password=masterkey;Database=E:\TEST.FDB;Dialect=3;Charset=UTF8;ServerType=1;

I didn't remember also IDPLicense.txt and IPLicense.txt, I believe we must also distribute all of them with the applying for license problem ?