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

Options
Board Support
Board Support Employee
5 Likes Photogenic
edited June 2023 in Support Articles

HOW TO FIX: DB EMPTY OR UNAVAILABLE WITH .NET FRAMEWORK ERROR MESSAGE IN SQL LOG

Symptoms - Popup message “database empty or unavailable” returned when connecting to a data source via ODBC/OLEDB

The following error messages :

  • Error: The 'DbProviderFactories' section can only appear once per config file.
  • Invalid Query: Unable to find the requested .NET Framework Data Provider. It may not be installed.

tracked in the SQLError log (popup message “database empty or unavailable”) might be related to a faulty installation/corruption of the .NET Framework.

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

Solution - In order to fix the above-mentioned issue, please follow the steps below

  • Identify the machine.config files (there may be several, based on how many versions of the framework are installed)

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

  • In each of those files, look for the section <system.data>
  • Remove any empty tag <DbProviderFactories/> and save the file
  • Restart the server [machine]

If the issue persists, you should:

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

Categories