Problem creating connection to SQL Server
Hello,
I am having trouble creating a connection to an SQL Server database. I have tried both LinqPad 4 and 5. Sometimes when I try to "test" the connection I get "The 'DbProviderFactories' section can only appear once per config file." Most of the time I get "Unable to find the requested .Net Framework Data Provider. It may not be installed."
I have many versions of the .NET Framework installed including 4, 4.5, 4.51, 4.5.2, 4.6, 4.6.1, 4.6.2.
Any ideas would be appreciated.
I am having trouble creating a connection to an SQL Server database. I have tried both LinqPad 4 and 5. Sometimes when I try to "test" the connection I get "The 'DbProviderFactories' section can only appear once per config file." Most of the time I get "Unable to find the requested .Net Framework Data Provider. It may not be installed."
I have many versions of the .NET Framework installed including 4, 4.5, 4.51, 4.5.2, 4.6, 4.6.1, 4.6.2.
Any ideas would be appreciated.
Comments
https://forums.asp.net/t/1693277.aspx?+DbProviderFactories+section+can+only+appear+once+per+config+file+error
There was an extra tag in my C:\windows\microsoft.net\Framework\v4.0.30319\Config\machine.config file.
I removed the extra tag, restarted LINQPad, and I'm up and running.