Live Chat Icon For mobile
Live Chat Icon

I get the error message ‘Keyword not supported: ‘provider”, when using Sql Server why?

Platform: ASP.NET| Category: ADO.NET

If you are using SqlConnection then the connection string should be as follows:


server=localhost;uid=sa;password=;database=northwind
i.e
server=<yourservername>;uid=<youruid>;password=<yourpassword>;database=<yourdbName>'

For SqlConnection we do not provide a Provider . Provider is used in cases where OleDbConnection is used.

Share with

Share on twitter
Share on facebook
Share on linkedin

Related FAQs

Couldn't find the FAQs you're looking for?

Please submit your question and answer.