SOLUTION: SQL Looping after Flare 9 installation

[marvin mallari]

Problem Description:
After a fresh install of Flare 9, the user is prompted to install SQL Server Compact Edition even though the application has already been installed.

Resolution:
Go to the following locations:

C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\Machine.Config
C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\Machine.Config

Open the Machine.config file in a text editor and search for “DbProviderFactories”.

The block to pay attention to is this:

Code: Select all

<system.data>
                <DbProviderFactories>
                        <add name="IBM DB2 for i5/OS .NET Provider" invariant="IBM.Data.DB2.iSeries" description=".NET Framework Data Provider for i5/OS" type="IBM.Data.DB2.iSeries.iDB2Factory, IBM.Data.DB2.iSeries, Version=12.0.0.0, Culture=neutral, PublicKeyToken=9cdb2ebfb1f93a26"/>
                        <add name="Microsoft SQL Server Compact Data Provider" invariant="System.Data.SqlServerCe.3.5" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</DbProviderFactories>
<!-- This is the line to remove - empty element --><DbProviderFactories/>
        </system.data>

Open Flare and voilà, the problem is resolved.
*Please Note: Users will need Administrator rights in order to edit the files.