System.ArgumentException: Keyword not supported: 'provider

john kanyora

Hi ..am getting this error while running my code: "System.ArgumentException: Keyword not supported: 'provider"

this is my web.config file where the error comes from:

connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0;HDR=YES;IMEX=1' " providerName="System.Data.OleDb"/>

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ankit Sharma9y ago
Accepted answer
Hi John,

Please refer to below link to get the solution for this problem

https://stackoverflow.com/questions/27387912/keyword-not-supported-provider-opening-sqlconnection
Ankit Sharma9y ago
Hi John,

If you are using an SQL connection try using OleDbConnection

https://forums.asp.net/t/1577701.aspx?Keyword+not+supported+provider+

or else try removing 'provider' keyword

https://social.msdn.microsoft.com/Forums/vstudio/en-US/77ff9db1-c69d-4a14-b606-d208832b8756/keyword-not-supported-provider?forum=netfxbcl

Hope this helps
john kanyora9y ago
Hi Ankit,

i have tried both the links on what they are suggesting but nothing really works..
kindly help me out its a task that my boss is now mad at me..kindly help me out
Ankit Sharma9y ago
Hi John,

Please refer to below link

https://stackoverflow.com/questions/14182927/keyword-not-supported-provider

Check your connection string by refering to this link

https://www.connectionstrings.com/access/
john kanyora9y ago
Hi Ankit,
i used the suggestion in that link but it still did not work..still giving me the same error