When System.Data.SQLite and .NET are both installed on the same machine it causes an error with IDT Timing Commander® in the machine.config files.

Error: System.Configuration.ConfigurationErrorsException: The 'DbProviderFactories' section can only appear once per config file.

Cause: When System.Data.SQLite and .NET are both installed on the same machine it causes an error in the machine.config files. Here’s an article describing the problem: http://stackoverflow.com/questions/23754055/sqlite-error-the-dbproviderfactories-section-can-only-appear-once-per-config

Solution: Check the machine.config files and remove the extra “<DbProviderFactories/>” tag. 

This excerpt below describes the location of the machine.config files:

The machine.config files are located in:

  • C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config
  • C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config
  • C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\machine.config
  • C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

The corrupted version of machine.config contains:

<system.data>

<DbProviderFactories>

<add name="IBM DB2 for i .NET Provider" invariant="IBM.Data.DB2.iSeries" description=".NET Framework Data Provider for IBM i" type="IBM.Data.DB2.iSeries.iDB2Factory, IBM.Data.DB2.iSeries, Version=12.0.0.0, Culture=neutral, PublicKeyToken=9cdb2ebfb1f93a26" />

   </DbProviderFactories>

   <DbProviderFactories/>

</system.data>

For other questions not addressed by the knowledge base, please submit a technical support request.