您的位置: 首页  >  技术问答  >  在Visual Studio中创建firebird数据源

在Visual Studio中创建firebird数据源

分类: 技术问答 • 2022-02-28 17:55:21

在Visual Studio中创建firebird数据源

问题描述：

我有一个应用程序在c＃使用Visual Studio 2010 express和实现了sqlce数据库，我使用不符合我们所有的需要。

I have an app in c# using Visual Studio 2010 express and realized the sqlce database i was using does not meet all of our needs.

我试图找出如何添加一个firebird数据源并指向我的firebird数据库。我想模仿sqlce数据集创建一个新的数据集，但与设计器。我认为我的第一步需要添加数据源，但我不知道如何做。有任何想法吗？

I am trying to figure out how to add a firebird datasource and point to my firebird database. I want to mimic the sqlce dataset creating a new dataset but with designer. I think my first step needs to be getting the data source added but I can't figure out how to do it. Any ideas?

我试过下面这篇文章：
http://www.ibprovider.com/eng/documentation/firebird_adonet/p2_visual_studio_2008.html#server_explorer
以及本文中的其他链接，但没有运气。我尝试安装ibprovider专业套件，它看起来像我所看到的程序文件，但我不知道它正在做什么正确。我还从easysoft安装了一个odbc提供程序。

I tried following this article: http://www.ibprovider.com/eng/documentation/firebird_adonet/p2_visual_studio_2008.html#server_explorer as well as additional links within this article but have not had luck. I tried installing the ibprovider professional suite and it looks like it insalled as i see it in program files but I am not certain what it is doing exactly. I also installed a odbc provider from the easysoft.

任何帮助将不胜感激。

Any help would be appreciated.

答

这是我做了这一段时间了。我记得对machine.config进行更改。看看这些，这些指令听起来很熟悉。 http://www.basarat.com/2010 /02/setting-up-firebird-development-with-vs.html http://www.basarat.com/2010/05/setting-up-portable-firebird-full-with.html

It's been a while since I've done this. I do remember making changes to the machine.config. Look at these, these instructions sound familiar. http://www.basarat.com/2010/02/setting-up-firebird-development-with-vs.html http://www.basarat.com/2010/05/setting-up-portable-firebird-full-with.html

编辑：
我刚刚安装它，这是我做的：

edit: I just installed it, this is what I did:


  • 我从 FireBirdClient.msi和DDEX提供程序
    nofollow>此处。

  • 安装.msi并解压缩
    DDEX zip。

  • 使用Visual Studio命令提示
    并导航到C：\Program文件
    （x86）\FirebirdClient。

  • 执行gacutil / i
    FirebirdSql.Data.FirebirdClient FYI

  • 然后，gacutil / l
    FirebirdSql.Data.FirebirdClient并离开

  • 我在
    中修改了我的machine.config C：\Windows \Microsoft.NET\Framework\v2 .0.50727\CONFIG
    AND C：\Windows \Microsoft.NET\Framework\v4.0.30319\Config
    并按照这些说明操作。

  • I downloaded the latest FireBirdClient.msi and DDEX provider from here.
  • Installed the .msi and extracted the DDEX zip.
  • Used the Visual Studio Command prompt and navigated to C:\Program Files (x86)\FirebirdClient.
  • Did gacutil /i FirebirdSql.Data.FirebirdClient FYI, after the .dll doesn't show up in the gac for some reason
  • Then, gacutil /l FirebirdSql.Data.FirebirdClient and left it open so I could copy the Version and PublicKeyToken later.
  • I modified my machine.config in C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG AND C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config and followd these instructions.

注意：％RuntimeVersion％与％版本％ 

<configuration>
  <configSections>
    ...
    <section name="firebirdsql.data.firebirdclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=%RuntimeVersion%, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    ...
  <configSections>
...
  <system.data>
    <DbProviderFactories>
      ...
      <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".Net Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=%Version%, Culture=%Culture%, PublicKeyToken=%PublicKeyToken%" />
      ...
    </DbProviderFactories>
  </system.data>
</configuration>

And substitute (these informations you can find using gacutil):
  - %RuntimeVersion% with either 2.0.0.0 (.NET 2.0, .NET 3.0, .NET 3.5) or 4.0.0.0 (.NET 4). 
  - %Version% with the version of the provider assembly that you have in the GAC.
  - %Culture% with the culture of the provider assembly that you have in the GAC.
  - %PublicKeyToken% with the PublicKeyToken of the provider assembly that you have in the GAC.




  • 从DDEX提取我复制
    两个.dll的
    FirebirdSql.VisualStudio.DataTools.dll
    和
    FirebirdSql.VisualStudio.DataToolsUI.dll
    到C：\Program文件（x86）\Microsoft
    Visual Studio 10.0 \Common7 \IDE。

    • From the DDEX extract I copyied the two .dll's FirebirdSql.VisualStudio.DataTools.dll and FirebirdSql.VisualStudio.DataToolsUI.dll to C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE.

      我做的最后一件事是从DDEX解压缩修改2
      注册表文件
      将每个的路径更改为
      C：\Program Files（x86）\Microsoft
      Visual Studio
      10.0 \Common7\I\DE\FirebirdSql.VisualStudio。 DataTools.dll
      并合并它们。

      The last thing I did was modify the 2 registry files from the DDEX extract changing the path for each to C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\I\DE\FirebirdSql.VisualStudio.DataTools.dll and merged them.

      编辑：添加此作为bline22在评论中指出的参考。

      edit: adding this as a reference noted by bline22 in the comments.

相关推荐