Thursday, May 12, 2016

Fixing "DBProviderFactories" section issue in SSDT / SSIS / SSMS







Recently , I installed SQL Server Data tools ( SSDT) after installing SQL Server 2014 . 

As mentioned in one of my post (http://mfzahirdba.blogspot.com/2016/02/sql-server-2014-surprises.html )  , SSDT is not bundled in the installer . You will need to download and install it.

After the install , I created a SSIS project , and created a data flow task. 
When , I am try to create a new connection manager , I was greeted (!) with this error. 






Here is how , I resolved the issue .

a)  Identify the correct machine.config in the .NET framework 
     In my case , it was  
   C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

b)  Remove one of the tags (DbProviderFactories in section  in "system.data" 
section

  
        

After the edit ,I was able to create the connection managers with no issue.


It looks like , when you install the ODBC / .NET drivers , it adds the additional tag into the .NET framework configuration file. 

Hope this is helpful .




No comments:

Post a Comment