Forum Discussion

errorssuck's avatar
errorssuck
Frequent Visitor
10 years ago
Solved

Error: Unable to find the requested .Net Framework Data Provider. It may not be installed.

Hello,   I am trying to create a gateway do connect to an on-prem SQL server 2012 DB via DirectQuery and the gateway was setup succesfully on the server. Now I am trying to create a datasource and ...
  • errorssuck's avatar
    errorssuck
    10 years ago

    Solved for it.!

     

    I have re-installed .NET framework and restarted the server and tried creating the data source and this time the error changed and it was saying something in the lines of there is an extra DbProviderFactories and from a quick web search I found this link that we need to edit the machine.config file to remove the extra entry of DbProviderFactories and I did the same and restarted the server and it worked like charm.

     

    Here is what I removed from the machine.config file.

     

    Hope this helps anyone who faces similar issues.

errorssuck's avatar
errorssuck
Frequent Visitor
10 years ago

Solved for it.!

 

I have re-installed .NET framework and restarted the server and tried creating the data source and this time the error changed and it was saying something in the lines of there is an extra DbProviderFactories and from a quick web search I found this link that we need to edit the machine.config file to remove the extra entry of DbProviderFactories and I did the same and restarted the server and it worked like charm.

 

Here is what I removed from the machine.config file.

 

Hope this helps anyone who faces similar issues.

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

errorssuck

 

Thanks for sharing the solution. Could you please mark your answer as solution to close this thread?

 

Best Regards,

Herbert