SQL Server 2005 Compact Edition - How is it deployed?

[Neil.Young]

Hi,

I have written a WinForm app using VS 2008. The app uses LINQ to SQL for a
SQL Server Compact Edition database. The Setup has only one requirement (by
default): .net 3.5 runtime.

Now I got a notice from a colleague of mine, reporting problems with running
my app on Windows XP, SP 2, .net 3.5 runtime installed. This machine doesn't
have any binaries of the Visual Studio environment installed, just plain
..net 3.5.

The error is self-explaining: "SQL Server Compact Edition 3.5 missing".

Obviously the setup does not automatically deploy the CE runtime to the
target. Is the separate installation of "SQL Server Compact 3.5" sufficient?
http://www.microsoft.com/downloads/...4f-67ab-481f-a5a5-4990597b0297&displaylang=en

Regards

 

[Arne Vajhøj]

I have written a WinForm app using VS 2008. The app uses LINQ to SQL for a
SQL Server Compact Edition database. The Setup has only one requirement (by
default): .net 3.5 runtime.

Now I got a notice from a colleague of mine, reporting problems with running
my app on Windows XP, SP 2, .net 3.5 runtime installed. This machine doesn't
have any binaries of the Visual Studio environment installed, just plain
.net 3.5.

The error is self-explaining: "SQL Server Compact Edition 3.5 missing".

Obviously the setup does not automatically deploy the CE runtime to the
target. Is the separate installation of "SQL Server Compact 3.5" sufficient?
http://www.microsoft.com/downloads/...4f-67ab-481f-a5a5-4990597b0297&displaylang=en

You can just ship some DLL's with your app.

I had an app using CE that worked with just:

System.Data.SqlServerCe.dll
sqlceme35.dll
sqlceqp35.dll
sqlcese35.dll

(depending on the features you use then you may need more DLL's)

Arne