I had to move an old existing application to a new application server (Windows 2012). Unfortunately, when starting the application and searching for an entity, it shows the following error message:
System.Web.Services.Protocols.SoapException: Server was unable to
process request. —> System.ArgumentException: The ADO.NET provider
with invariant name ‘System.Data.SqlClient’ is either not registered
in the machine or application config file, or could not be loaded. See
the inner exception for details. —> System.ArgumentException: Unable
to find the requested .Net Framework Data Provider. It may not be
Do you know why this is happening?
- Do I need to install something so that the System.Data.SqlClient is available?
I checked the connectionstring and it looks like this:
<add name="<connectionname>" connectionString="Data Source=<serverinstance>;Initial Catalog=<dbname>;User Id=<username>;Password=<password>;Connection Timeout=180;Application Name=app_trace" providerName="System.Data.SqlClient" />
Additional info: we use EntityFramework 6
Thanks in advance