FairCom ADO.NET Driver - Developer's Guide

Visual Studio DDEX Provider for FairCom DB

Note: This topic explains how the FairCom installer integrates the ADO provider inside Visual Studio. You should not need to perform these procedures by hand. If you have problems, you can refer to this topic to check that things are properly set up.

The DDEX Provider for FairCom ACE provides integration of FairCom .NET Data Adapter into Visual Studio.

Before you can use it, the following steps must be completed:

1. The FairCom .NET Data Adapter DLL (Ctree.Data.SqlClient.dll) must be put in the GAC (simply copy it to the C:\Windows\Assembly folder or use the Microsoft .NET Configuration tool).
2. The DLL in Step 1 must be registered in the machine.config file. The file should be located in the following directory:

   C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\CONFIG

   To register the provider, add the following to the machine.config file:

   <configuration>

   <configSections>

   ...

   <section name="ctree.data.sqlclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

   ...

   <configSections>

   <system.data>

   <DbProviderFactories>

   ...

   <add name="FairCom DB SQL Data Provider" invariant="Ctree.Data.SqlClient" description=".Net Framework Data Provider for FairCom SQL" type="Ctree.Data.SqlClient.CtreeSqlClientFactory, Ctree.Data.SqlClient, Version=10.5.0.0, Culture=neutral, PublicKeyToken=0ce73727dc1039a8" />

   ...

   </DbProviderFactories>

   </system.data>

   ....

   </configuration>

3. Information should be added to the Windows registry. You can find this information in the FairCom DB Professional ReadMe First in the FairCom DB Professional Installed Components chapter:

If needed, the FairComDDEXProvider.reg file must be modified to set the correct CodeBase for the DDEX provider files (replace the current DLL path in the file with the correct path).

Attention: The path separator must be a double backslash ( \\ )