Keyword not supported: 'data source' in ASP.net Entity Framework 6

asp.net c# connection-string entity-framework sql-server

Question

I've been poking my brain around for a few days trying to figure this out.

I'm using winhost to host a SQL Server and I've looked up quite a few similar questions with the same issue but they all seemed to have some formatting error that was their issue.

What's wrong with my connection string?

<add name="ContactsDb"
     connectionString="Data Source=tcp:s10.winhost.com;Initial Catalog=DB_84426_webdevct;User ID=DB_84426_webdevct_user;Password=***********;Integrated Security=False;" 
     providerName="System.Data.EntityClient"/>
1
7
1/27/2015 6:20:14 AM

Popular Answer

I had to change the provider name to System.Data.SqlClient from System.Data.EntityClient. I was mistaken in thinking I needed the EntityClient for the automagic powers of Entity Framework when connecting to an external SQL Server database. Thank you Paresh J.

9
1/27/2015 6:20:46 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow