Why am I getting "Unable to find the requested .Net Framework Data Provider" when trying to setup a new datasource in Visual Studio 2010 Professional?
My stats:
- Windows 7 64bit 16gig RAM
- Visual Studio 2010 Professional
- SQL Server 2008 (server A, full admin rights)
- SQL Server 2008 (server B, full admin rights)
I have started a test ASP.NET application and when I try to add a new data source, I get:
Unable to find the requested .Net Framework Data Provider. It may not be installed.
I have .NET 4 installed.
When I build the connection and click "Test Connection" it tests successful. SQL Server Management Studio connects just fine and I have verified the credentials on everything.
Best Answer
I have seen reports of people having and additional, self terminating node in the machine.config file. Removing it resolved their issue. machine.config is found in
\Windows\Microsoft.net\Framework\vXXXX\Config
. You could have a multitude of config files based on how many versions of the framework are installed, including 32 and 64 bit variants.