SyntaxFix

[asp.net] SQL providerName in web.config

System.Data.SqlClient is the .NET Framework Data Provider for SQL Server. ie .NET library for SQL Server.

I don't know where providerName=SqlServer comes from. Could you be getting this confused with the provider keyword in your connection string? (I know I was :) )

In the web.config you should have the System.Data.SqlClient as the value of the providerName attribute. It is the .NET Framework Data Provider you are using.

<connectionStrings>
   <add 
      name="LocalSqlServer" 
      connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" 
      providerName="System.Data.SqlClient"
   />
</connectionStrings>

See http://msdn.microsoft.com/en-US/library/htw9h4z3(v=VS.80).aspx

Examples related to asp.net

• RegisterStartupScript from code behind not working when Update Panel is used • You must add a reference to assembly 'netstandard, Version=2.0.0.0 • No authenticationScheme was specified, and there was no DefaultChallengeScheme found with default authentification and custom authorization • How to use log4net in Asp.net core 2.0 • Visual Studio 2017 error: Unable to start program, An operation is not legal in the current state • How to create roles in ASP.NET Core and assign them to users? • How to handle Uncaught (in promise) DOMException: The play() request was interrupted by a call to pause() • ASP.NET Core Web API Authentication • Could not load file or assembly 'CrystalDecisions.ReportAppServer.CommLayer, Version=13.0.2000.0 • WebForms UnobtrusiveValidationMode requires a ScriptResourceMapping for jquery

Examples related to sql-server-2005

• Add a row number to result set of a SQL query • SQL Server : Transpose rows to columns • Select info from table where row has max date • How to query for Xml values and attributes from table in SQL Server? • How to restore SQL Server 2014 backup in SQL Server 2008 • SQL Server 2005 Using CHARINDEX() To split a string • Is it necessary to use # for creating temp tables in SQL server? • SQL Query to find the last day of the month • JDBC connection to MSSQL server in windows authentication mode • How to convert the system date format to dd/mm/yy in SQL Server 2008 R2?

Examples related to connection-string

• Get ConnectionString from appsettings.json instead of being hardcoded in .NET Core 2.0 App • How to read connection string in .NET Core? • Connect to SQL Server Database from PowerShell • System.Data.SqlClient.SqlException: Login failed for user • Entity Framework change connection at runtime • A network-related or instance-specific error occurred while establishing a connection to SQL Server • How can I set an SQL Server connection string? • VB.NET Connection string (Web.Config, App.Config) • Connection string using Windows Authentication • How to find SQL Server running port?