Well, it's quite clear that the connection string formed has issues.
I would suggest you to have a loot here at
Connection String[
^]!
The link above provides all info about connection string. Further info regarding the data communication can be read here:
Accessing data with ADO.NET[
^]
Out here, you are working with SQL, you don't need to give the provider. Just
remove the Provider and things should be fine.