在Visual Studio中创建firebird数据源 [英] Create firebird data source in Visual Studio

问题描述

我有一个应用程序在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.

    这篇关于在Visual Studio中创建firebird数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！