Connection string SQL Compact 3.5 versus 4.0

Category: sql server ce


Chris Schog on Wed, 15 Nov 2017 06:52:41


I am developing since some years an C# application using an SQL Compact 3.5 database together. But after changing my computer and environment I have now only the System.Data.SqlServerCe version 4.0 as an assembly in my project. I don't know how to get here the version 3.5. As long as I only use the existing database everything is working but when I try to change the schema of the database within my program I get the message "wrong database version". 

Is there a simple way to change the System.Data.SqlServerCe to version 3.5?


Chris Schog on Wed, 15 Nov 2017 07:57:15


is there a difference in connecting SQL Compact 3.5 or SQL Compact 4.0? I am using C# in VS2017


Fletch Zhou on Thu, 16 Nov 2017 05:22:26

Hi friend,

Have you installed SQL Server Comoact 3.5 SP2 runtime?

Feel free to let me know if it works.




MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

ErikEJ on Mon, 27 Nov 2017 12:26:32

You must reference different versions of System.Data.SqlServerCe.dll for each version:

For 3.5: AssemblyVersion 3.5.1

For 4.0: AssemblyVersion 4.0.0

Please mark as answer, if this was it. Visit my SQL Server Compact blog