Db empty or unavailable with .NET framework error message in SQL Log

Document created by ggallo Employee on Sep 18, 2017
Version 1Show Document
  • View in full screen mode

You might incur in the following error messages 

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

or

Invalid Query: Unable to find the requested .NET Framework Data Provider. It may not be installed.

 

This is might be related to Microsoft Visual Studio being installed on the same computer. 

When Microsoft Visual Studio is updated (new version or patch) an empty <DbProviderFactories/> may be added to the machine.config file.

There may be several of these files, such as:

• 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

 

Solution:

In each .NET machine.config file on your computer, look for the section <system.data>. 

Remove any empty XML tag <DbProviderFactories/> and save the file.

 

After saving the file, you should:

- Uninstall BOARD Server and BOARD Client
- Uninstall .NET Framework 4 e 3.5
- Re-install all components (.NET Framework 3.5 from roles, .NET Framework 4, all prerequisites for BOARD Client and Server, BOARD Server and BOARD Client)
- Restart the OS

2 people found this helpful

Attachments

    Outcomes