Issue with GAC and Microsoft SQL Server Compact 4.0

Question

Hello

I have an application that I developed using VS Express 2012 for Windows Desktop.  It worked fine the first time it was installed in a Windows 8 computer.  Then I made changes and now I can not get the new version to install.  I get the following message "No se puede instalar ni ejecutar esta aplicación. Debe instalar primero el ensamblado Microsoft.SqlServerCe versión 4.0.0.0. en la cache de ensamblados global (GAC)"

What do I need to do to fix this problem?  Could it be because I am developing in English and the user uses it in Spanish?

Thank you.

Answer 1

Hi Irene09,

Based on the error message, please download and install Server Compact 4.0.

Microsoft SQL Server Compact 4.0
http://www.microsoft.com/en-us/download/details.aspx?id=17876

---

Allen Li
TechNet Community Support

Answer 2

The user already installed that.  And it worked the first time.  It was once I made changes and rebuilt that it gave him the error.  I will have him install it again.  Should he install the English version instead of the Spanish one?.  Is there a difference?

Thank you

Answer 3

 

It didn't work.  Any other ideas?

Thanks

Answer 4

Hi, we need to make sure you have updated any Project references to point to the 4.0 managed DLL which usually located at: C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Desktop (System.Data.SqlServerCe.dll). You can also refer to the following thread:

http://social.msdn.microsoft.com/Forums/hu-HU/sqlce/thread/6380d071-3a59-45aa-8c09-d6f068189df4

---

Allen Li
TechNet Community Support

Answer 5

I changed the reference System.Data.SqlServerCe Copy Local from False to True and it works. 

Thank you.