‘DbProviderFactories’ section can only appear once per config file error’ – MS SQL DTS wizard

ENGLISH

I had this problem after few months of using SQL Express 2012. At start of Import and Export data (DTSWizard) I got this error. At first I uninstalled SQL and reinstalled it again but the error was still here. After some “googling” I found the sollution.

The problem lies in installation of Visual Studio 2010. Look at this two files:

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

In each find this section:

<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>
<!-- here we delete this line where it is the not necessary element --><DbProviderFactories/>
        </system.data>

Thanks to  bbcompent1 who found this solution!

 

SLOVENSKO

Na to težavo sem naletel, ko sem že nekaj časa imel namešen SQL Express 2012. Pri zagonu Import and Export data (DTSWizard) sem dobil zgornjo napako. Najprej sem sql odinštaliral in ga ponovno namestil ampak je bila napak še vedno prisotna. Po nekaj brskanja po googlu sem našel rešitev.

Problem je v namestitvi Visual Studio 2010. Poglej te dve datoteki:

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

V vsaki pošči del kjer je odsek :

<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>
<!-- tukaj izbrišemo vrstico kjer je odvečni element --><DbProviderFactories/>
        </system.data>

Hvala bbcompent1, ki je našel rešitev.