Mar 25, 2017 - NET, Databases in general, Firebird, Visual Studio. Visual Studio hit the shelves few weeks ago and it would be nice to install DDEX provider. How can the answer be improved? Sl j1660 driver.
Contents • • • • • • Install Firebird Client Library The first step in this process is to install the Firebird.NET Client Library, which can be downloaded from the. Download the client library and install it in its default location.
Add the Providers to the Registry Now download the DDEX Provider and.NET Data Provider installers from the, you can find the DDEX installer at the bottom of the page. Run the installers, installing the providers in the C: Program Files FirebirdClient directory. Once these are installed you need to edit the FirebirdDDEXProviderPackageLess32.reg or FirebirdDDEXProviderPackageLess64.reg if you are running a 64 bit operating system. Locate the%path% marker and replace it with the install path of the providers. With the default install you should end up with the following.
Warning: Make sure you use as the path separators, e.g. C: Program Files FirebirdClient Update the machine.config The next step involves the modification of your machine.config.
You can locate this file in either C: WINDOWS Microsoft.NET Framework v2.0.50727 CONFIG machine.config or C: WINDOWS Microsoft.NET Framework64 v2.0.50727 CONFIG machine.config on 64-bit systems. Open the file with any text editor, it contains XML configuration details used to configure.NET applications running on this machine. Before we edit this file we need to determine some information about the.NET providers that are supplied with the.NET data provider.
Open a.NET 2.0 SDK Command Prompt at the prompt enter. Microsoft (R).NET Global Assembly Cache Utility. Version 2.0.50727.42 Copyright (c) Microsoft Corporation. All rights reserved. The Global Assembly Cache contains the following assemblies: FirebirdSQL.data.FirebirdClient, Version=2.0.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL With this information you can now add the following two lines into the machine.config.
Note the use of the version, culture, and public key token in the second line. Use the details that you get from running the gacutil instruction if they differ from the details shown here. Installing the Embedded Driver At this stage the required changes have been made for Visual Studio to present its designers, allowing you to configure connections, data adapters, data sources, and table adapters etc. If you are using an embedded database you will also need to install the database drivers so that Visual Studio can load these to interact with your databases. Download the embedded driver from the.
Extract the DLL files into your system32 directory within the windows directory (i.e. C: Windows System32). With these files installed here Visual Studio will be able to load the database to extract the schema information that it requires to automate the code generation. Inside Visual Studio If you run Visual Studio now you should be able to do the following: • Add a new Data Connection in the Server Explorer • Add Data Sources to your projects • etc.