如何使用 Visual C# 2010 连接和使用 Firebird db 嵌入式服务器 [英] How to connect and use Firebird db embedded server with Visual C# 2010

问题描述

我试图将 Firebird 嵌入式服务器与 Microsoft Visual C# 2010 一起使用.所以这是我到目前为止所做的:

I was trying to use Firebird embedded server with Microsoft Visual C# 2010. so here is what I done till now:

1. 已下载 Firebird .Net 数据提供程序(火鸟客户端 v2.5.2).

已下载 Firebird 嵌入式服务器(火鸟嵌入式服务器 v2.5.0).

在我的项目中添加了对 FirebirdSql.Data.FirebirdClient.dll 的引用.

Added a reference to FirebirdSql.Data.FirebirdClient.dll to my project.

提取并复制 fbembed.dll 文件到我的应用程序的目录.

将我的 FDB 文件 TEST.FDB"添加到我的应用程序的目录中.

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

添加了using FirebirdSql.Data.FirebirdClient;"语句.

到目前为止一切顺利(我想)......

So far so good (I suppose)...

现在，当我尝试使用以下代码连接到我的 FDB 文件时:

Now when I try to connect to my FDB file using the 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());
         }

我总是收到消息框，这意味着代码没有正确连接到我的数据库文件.难道我做错了什么?我真的还是 C# 的菜鸟，我不知道如何做到这一点或修复它，我希望有人能帮助我.

I always get the messagebox which means the code is not connecting to my DB file properly. am I doing something wrong? I'm really still noob with C# and I have no idea how to do this or fix it and I hope someone will help me with this.

谢谢:)

这是我在异常中得到的:

here is what I get in the exception:

FirebirdSql.Data.FirebirdClient.FbException(0x80004005): 无法完成对主机127.0.0.1"的网络请求.---> 无法完成对主机127.0.0.1"的网络请求.在FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()在FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create()在FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut()在FirebirdSql.Data.FirebirdClient.FbConnection.Open()在fbTestApp.Form1.button1_Click(对象发件人，EventArgs e) 在 C:Documents和 SettingsermacMy DocumentsVisual工作室2010ProjectsfbTestAppfbTestAppForm1.cs:行25

FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Unable to complete network request to host "127.0.0.1". ---> Unable to complete network request to host "127.0.0.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

推荐答案

经过6个小时的工作，我终于找到了解决方案:)

I finally I found the solution after 6 hours of work :)

谷歌上的大多数答案要么是错误的，要么是太旧了.他们都说我只需要将 fbembed.dll 文件包含到我的项目中..

most of answers on google are either wrong or so old. all of them say that I only need to include fbembed.dll file to my project..

经过我的一些调查.我发现我还需要将 firebird.msg、firebird.conf、icudt30.dll、icuin30.dll、icuuc30.dll 和 ib_util.dll 添加到我的项目 文件和 输出文件夹..

after some investigations I made. I found that I also need to add firebird.msg, firebird.conf, icudt30.dll, icuin30.dll, icuuc30.dll and ib_util.dll to my project files and to the output folder..

重要提示:切勿使用紧凑的 .Net 数据提供程序.因为他们只为普通和超级火鸟服务器制作了它.它不适用于嵌入式服务器.

important notice: never use compact .Net data provider. because they made it for Normal and super firebird servers only. it won't work with embedded servers.

这篇关于如何使用 Visual C# 2010 连接和使用 Firebird db 嵌入式服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！