Hi Desigal59,
Based on my research, the error Unable to find the requested .Net Framework Data Provider. It may not be installed. (System.Data) always caused by having and additional, self terminating node in the machine.config file.
You could find a multitude of machine.config files based on how many versions of the framework are installed, including 32 and 64 bit variants at the place:
\Windows\Microsoft.net\Framework\vXXXX\machine.config
The machine.config file has the following configuration file fragment:
<system.data>
<DbProviderFactories>
<add name="Odbc Data Provider" invariant="System.Data.Odbc" ... />
<add name="OleDb Data Provider" invariant="System.Data.OleDb" ... />
<add name="OracleClient Data Provider" invariant="System.Data ... />
<add name="SqlClient Data Provider" invariant="System.Data ... />
<add name="IBM DB2 for i .NET Provider" invariant="IBM.Data ... />
<add name="Microsoft SQL Server Compact Data Provider" ... />
</DbProviderFactories>
<DbProviderFactories/> //remove this one
</system.data>
Notice the CLOSING tag at end of the <DProviderFactories> last item, in this case the "Microsoft SQL Server Compact Data Provider", and then there's another SELF CLOSING <DBProviderFactories> tag. Clean this up by keeping the
one after the last item and deleting the self closing one at the end can fix this issue.
References:
http://stackoverflow.com/questions/9928361/unable-to-find-the-requested-net-framework-data-provider-in-visual-studio-2010
https://social.msdn.microsoft.com/Forums/vstudio/en-US/7b4f353b-77fd-427c-976b-5968abc88c13/visual-studio-2010-unable-to-find-the-requested-net-framework-data-provider-for-sql?forum=vseditor
https://msdn.microsoft.com/en-us/library/dd0w4a2z(v=vs.90).aspx
Thanks,
Katherine Xiong