All geek questions in one place

Cannot open SQL CE 4 databases in VS 2010 SP1

According to Gu, in VS 2010 SP1 (http://weblogs.asp.net/scottgu/archive/2011/01/11/vs-2010-sp1-and-sql-ce.aspx) I should be able to open databases SQL CE 4 Data.

However, when I try to do this, I get the following error:

"The data provider needed to connect to the local data file cannot be found. The file will be added to the project using the typed DataSet associated with the file, it will not be generated."

followed by an error:

"The operation could not be completed"

Please note that this is for an ASP.NET MVC project.

+4
source share
2 answers

SQL Compact 4 tools have some limitations described here (in scripts not included with SQL Server Compact 4.0) - http://blogs.msdn.com/b/sqlservercompact/archive/2011/01/12/microsoft-sql-server -compact-4-0-is-available-for-download.aspx In addition to the service pack, you must install the SQL Server Compact 4 tools on top - http://erikej.blogspot.com/2010/12/visual-studio-tools -for-sql-server.html

+3
source

My “solution” was to simply open the database in a web matrix to change the schema.

Perhaps this was just a problem with the beta version of VS 2010 SP1.

0
source

Source: https://habr.com/ru/post/1339068/

More articles:


All Articles