locked
SQL Server Data Tools and missing ".net framework data provider"

    Question

  • I just installed SQL 2012 RTM and SSDT RTW on Win 7 x64. I already had VS 2010 SP1. I made a new database project and tried to "import database" - "new connection". On the connection properties screen I always get "unable to find the requested .net framework data provider. It may not be installed".

    I have SQL compact 4.0 installed. How do I add all the data providers?

    Thanks

    Friday, March 16, 2012 2:30 PM

Answers

  • The solution was to remove the extra empty DbProviderFactories element in machine.config: http://social.msdn.microsoft.com/Forums/nl-NL/vseditor/thread/7b4f353b-77fd-427c-976b-5968abc88c13
    • Marked as answer by wtjones Monday, March 19, 2012 7:10 PM
    Monday, March 19, 2012 7:10 PM

All replies

  • The solution was to remove the extra empty DbProviderFactories element in machine.config: http://social.msdn.microsoft.com/Forums/nl-NL/vseditor/thread/7b4f353b-77fd-427c-976b-5968abc88c13
    • Marked as answer by wtjones Monday, March 19, 2012 7:10 PM
    Monday, March 19, 2012 7:10 PM
  • Hello wtjones,

    Glad to hear you have had your issue resolved. And thanks for sharing us your solution here.

    Have a nice day.


    Vicky Song [MSFT]
    MSDN Community Support | Feedback to us

    Tuesday, March 20, 2012 2:11 AM
    Moderator
  • I had same issue with a small variation.

    In my case the System.data section of the machine.cofig file only had this (the one lacated here C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config):

      <system.data>
            <DbProviderFactories/>
        </system.data>

    So to fix it I added all the providers from the same file here C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG

     <system.data>
        <DbProviderFactories>
          <add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
          <add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
          <add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
          <add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
          <add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
          <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>
      </system.data>


    Help Others! Don't forget to mark your thread as answered

    Rafael Salas - SSIS and more

    Friday, April 27, 2012 2:06 PM
  • Vicky

    I'm facing the same problem, and I did the modification above but I was unable to save the machine.config file.

    When I try to save I receive this message:

    Access to the path C:\..... machine.config is denied.

    Thanks to any help!

    CESenna

    Tuesday, September 3, 2013 11:43 AM
  • Try launching your text editor with admin rights. If you still get the error, see if the file is locked via process explorer.
    Tuesday, September 3, 2013 4:11 PM
  • Thanks a lot.

    I downloaded the MS XML text editor launched it with admin rights and could change the machine.config

    Wednesday, September 4, 2013 12:07 AM