How to make friends with Visual Studio 2005/2008 with Firebird ADO.NET Data Provider
Good day readers Habra.
In this article I want to tell you about how to configure Visual Studio 2005/2008 to work with Firebird in visual mode.
Recently I was faced with the task of writing a small application under .net using the Firebird database. Everything is good, but it is impossible to connect Firebird to the visual editor with standard tools, but I didn’t want to write everything with pens, and the task is not the same.
A little googling stumbled upon a solution from IBProvider - a good thing but paid. Continuing my research found a free solution. About its installation and tell.
1. If there is no Firebird, then download it from here. Firebird
2. We need a .net client for Firebird - here we take the Firebird .NET client
3. After you have installed steps 1 and 2, we do the following. We start Visual Studio 2005/2008 Command Prompt and write the following line in the console that appears: gacutil.exe / l FirebirdSql.Data.FirebirdClient . In response, we get about the following:
')
Microsoft ® .NET Global Assembly Cache Utility. Version 3.5.21022.8
Copyright © Microsoft Corporation. All rights reserved.
The Global Assembly Cache contains the following assemblies:
FirebirdSql.Data.FirebirdClient, Version = 2.5.0.0, Culture = neutral, PublicKeyToken = 3750abcc3150b00c, processorArchitecture = MSIL
Number of items = 1
from this we need Version and PublicKeyToken.
4. Download and unpack to any place. Net provider for Firebird
Firebird DDEX provider
5. Now you need to slightly correct the machine.config file - I have it located at C: \ Windows \ Microsoft .NET \ Framework \ v2.0.50727 \ CONFIG \
In this XML we need to add two lines first to section
and second
In both lines, we replace the Version and PublicKeyToken values ​​with those obtained in step 3.
6. Next we go to the pack in which we unpacked FirebirdDDEXProvider and look for the file FirebirdDDEXProvider32.reg or FirebirdDDEXProvider64.reg there, depending on what OS you have. It needs to be edited a bit. Inside the file, we find the% Path% variable and enter the path to the folder where FirebirdDDEXProvider is unpacked (the path must be specified via //). Then double-click on the file to make changes to the registry.
All is ready!!! Now, by running Visual studio, we can create a connection to the Firebird database using visual development tools. Good luck.
In this article I want to tell you about how to configure Visual Studio 2005/2008 to work with Firebird in visual mode.
Recently I was faced with the task of writing a small application under .net using the Firebird database. Everything is good, but it is impossible to connect Firebird to the visual editor with standard tools, but I didn’t want to write everything with pens, and the task is not the same.
A little googling stumbled upon a solution from IBProvider - a good thing but paid. Continuing my research found a free solution. About its installation and tell.
1. If there is no Firebird, then download it from here. Firebird
2. We need a .net client for Firebird - here we take the Firebird .NET client
3. After you have installed steps 1 and 2, we do the following. We start Visual Studio 2005/2008 Command Prompt and write the following line in the console that appears: gacutil.exe / l FirebirdSql.Data.FirebirdClient . In response, we get about the following:
')
Microsoft ® .NET Global Assembly Cache Utility. Version 3.5.21022.8
Copyright © Microsoft Corporation. All rights reserved.
The Global Assembly Cache contains the following assemblies:
FirebirdSql.Data.FirebirdClient, Version = 2.5.0.0, Culture = neutral, PublicKeyToken = 3750abcc3150b00c, processorArchitecture = MSIL
Number of items = 1
from this we need Version and PublicKeyToken.
4. Download and unpack to any place. Net provider for Firebird
Firebird DDEX provider
5. Now you need to slightly correct the machine.config file - I have it located at C: \ Windows \ Microsoft .NET \ Framework \ v2.0.50727 \ CONFIG \
In this XML we need to add two lines first to section
<configuration> <br/>
<configSections> <br/>
<section name="firebirdsql.data.firebirdclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <br/>
</configSections> <br/>
</configuration>
and second
<system.data> <br/>
<DbProviderFactories> <br/>
<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=2.5.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c" /> <br/>
</DbProviderFactories> <br/>
</system.data> <br/>
In both lines, we replace the Version and PublicKeyToken values ​​with those obtained in step 3.
6. Next we go to the pack in which we unpacked FirebirdDDEXProvider and look for the file FirebirdDDEXProvider32.reg or FirebirdDDEXProvider64.reg there, depending on what OS you have. It needs to be edited a bit. Inside the file, we find the% Path% variable and enter the path to the folder where FirebirdDDEXProvider is unpacked (the path must be specified via //). Then double-click on the file to make changes to the registry.
All is ready!!! Now, by running Visual studio, we can create a connection to the Firebird database using visual development tools. Good luck.
Source: https://habr.com/ru/post/86823/
All Articles