DDEX

From InterBase

Go Up to ADO.NET Driver


The DDEX driver is included on the Installation package. When you install the ADO.NET driver, the installation process modifies both machine.config files found at C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config and C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config. You can open each one and verify that inside <DbProviderFactories> you have:

"InterBaseSql.Data.InterBaseClient" description=".NET Framework Data Provider for InterBase" type="InterBaseSql.Data.InterBaseClient.InterBaseClientFactory, InterBaseSql.Data.InterBaseClient, Version=7.10.2.0, Culture=neutral, PublicKeyToken=73f45bff97b4c31b"/>

The version number should match your installed version.

Note:
machine.config must have only one entry for InterBaseSQL.Data.InterBaseClient.dll


Starting with version 2017 the registry for Visual Studio moved to a private registry, this means you need to add registry entries manually. Before VS2017, Visual Studio stored its configuration in the Windows registry in HKLM and HKCU. Now, The configuration resides in a private registry, the privateregistry.bin file in %AppData%\Local\Microsoft\VisualStudio\15.0_<something> or 16.0_<something>. The rest is the same as previous versions.

Modifying Files

The installer copies two .reg files, one for VS2017 InterBaseDDEXProviderVS2017.reg and one for VS2019 InterBaseDDEXProviderVS2019.reg on <install_path>\InterBaseDDEX the default location should be C:\Program Files (x86)\InterBaseDDEX.

Note:
The following instructions use VS2019 but they also apply for VS2017.


First, you need to set the provider location.

  1. Open the file InterBaseDDEXProviderVS2019.
  2. Find the line "CodeBase"="%PATH%\\InterBaseSql.VisualStudio.DataTools.dll".
    Codebase.png
  3. Change %PATH% to the location of the DDEX driver. If you are using the default path it should look like: "CodeBase"="C:\\Program Files (x86)\\InterBaseDDEX\\InterBaseSql.VisualStudio.DataTools.dll".
    CodeBaseMod.png
  4. Save your changes.


Next, update the hive names.

  1. Go to C:\Users\<user>\AppData\Local\Microsoft\VisualStudio\. You should see a folder with a name like <version>_<random value> for example 16.0_9bdad857, this is the hive name.
  2. Update the .reg file so all entries have the same hive names.
    For example, if the folder is called 16.0_9bdad857 this line:
    [HKEY_USERS\16.0_d30585a1\Software\Microsoft\VisualStudio\16.0_d30585a1_Config\DataSources\{108473C1-273A-41BF-AE1E-CA515C423B9F}]
    Should change to:
    [HKEY_USERS\16.0_9bdad857\Software\Microsoft\VisualStudio\16.0_9bdad857_Config\DataSources\{108473C1-273A-41BF-AE1E-CA515C423B9F}]
  3. Save your changes.

Importing to Registry

  1. Launch Regedit
  2. Select HKEY_USERS
  3. On the menu select File > Load Hive...
  4. Load the privateregistry.bin file (for VS 2019 it is usually located at C:\Users\<user>\AppData\Local\Microsoft\VisualStudio\<version>_<random value>)
  5. When prompted for a name you can use the same hive name as the modified reg file.
    Note:
    VS cannot be running when loading privateregistry.bin.
  6. Go to to the reg file location e.g. C:\Program Files (x86)\InterBaseDDEX\ and merge it to the registry.
  7. Once the reg file is merged you must unload the hive from RegEdit and close it before you launch Visual Studio.

Advance To: