How to make friends Visual Studio 2005/2008 with Firebird ADO.NET Data Provider
Good afternoon readers of Habr.
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 for .net using the Firebird database. Everything is fine, but I can’t connect it to the Firebird visual editor using standard tools, but I didn’t want to write everything with pens, and the task is not the same.
A little google came across a solution from IBProvider - a good thing but paid. Continuing his research, he found a free solution. I will tell you about its installation.
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 installing 1 and 2 steps, do the following. We start Visual Studio 2005/2008 Command Prompt and in the appeared console we write the following line gacutil.exe / l FirebirdSql.Data.FirebirdClient. In response, we get something like this:
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 .net provider to any place. Firebird
Firebird DDEX provider
5. Now you need to fix the machine.config file a little - I have it at C: \ Windows \ Microsoft.NET \ Framework \ v2.0.50727 \ CONFIG \
In this XML, we need to add two lines, the first to the section and the second In both lines replace the Version and PublicKeyToken values with those obtained in step 3. 6. Next, go to the package into which FirebirdDDEXProvider was unpacked and look for the file FirebirdDDEXProvider32.reg or FirebirdDDEXProvider64.reg there, depending on which OS you have. It needs to be edited a little. Inside the file we find the variable% Path% and enter the path to the folder where FirebirdDDEXProvider is unpacked (the path must be specified through //). Next, double-click on the file to make changes to the registry.
All is ready!!! Now by launching 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 for .net using the Firebird database. Everything is fine, but I can’t connect it to the Firebird visual editor using standard tools, but I didn’t want to write everything with pens, and the task is not the same.
A little google came across a solution from IBProvider - a good thing but paid. Continuing his research, he found a free solution. I will tell you about its installation.
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 installing 1 and 2 steps, do the following. We start Visual Studio 2005/2008 Command Prompt and in the appeared console we write the following line gacutil.exe / l FirebirdSql.Data.FirebirdClient. In response, we get something like this:
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 .net provider to any place. Firebird
Firebird DDEX provider
5. Now you need to fix the machine.config file a little - I have it at C: \ Windows \ Microsoft.NET \ Framework \ v2.0.50727 \ CONFIG \
In this XML, we need to add two lines, the first to the section and the second In both lines replace the Version and PublicKeyToken values with those obtained in step 3. 6. Next, go to the package into which FirebirdDDEXProvider was unpacked and look for the file FirebirdDDEXProvider32.reg or FirebirdDDEXProvider64.reg there, depending on which OS you have. It needs to be edited a little. Inside the file we find the variable% Path% and enter the path to the folder where FirebirdDDEXProvider is unpacked (the path must be specified through //). Next, double-click on the file to make changes to the registry.
All is ready!!! Now by launching Visual studio we can create a connection to the Firebird database using visual development tools. Good luck.