Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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"/>
like image 429
Buzzyboy Avatar asked Jan 27 '15 04:01

Buzzyboy


1 Answers

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.

like image 191
Buzzyboy Avatar answered Oct 14 '22 12:10

Buzzyboy