System.ArgumentException: Keyword not supported: 'provider'.

I got this error for the first time i am using SQLServer database with my VS 2008.

I done every thing correctly but still i got this.

Finally i found the solution is that.

Here i am using SqlConnection so the provider should not be provided in the connection string



Error i made in connection String is

Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=5pmto8pm;Data Source=chitturi\sqlexpress

Correction is

Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=5pmto8pm;Data Source=chitturi\sqlexpress

Thats it..

It solved my problem...