Visual Studio Setup Project Installer Prerequisite for SQL Server CE

Question

I have a Setup Project in my solution in Visual Studio 2008 SP1. The application installs fine but it is not loading my prerequisite of SQL Server CE.

I have the following configurations set:

Do I need to do anything else, like with a Custom Action or anything like that? Thanks.

Answer 1

I would suggest that you try private file–based deployment (deploying the SQL Server Compact 3.5 DLLs as part of the project) instead.

If you deploy this way you will circumvent this problem and also

• Users do not need administrative credentials to install the application.

• Can also use ClickOnce deployment

Another upside (or in some rare cases downside) will be that the deployment will not be serviced by the Microsoft Update...

Answer 2

Choose prerequisites from the same location.