CSharp/C# >> VS 2005 Setup - How to add dependencies for SQL Server CE?

by Neil.Young » Mon, 09 Jun 2008 02:19:55 GMT

Hi,

I have created a small WinForm app, using SQL Server CE 3.1. The application
uses an installer, created using the means of VS 2005. I see a dependency
for .net 3.5 in the installer, so my setup asks the user for his agreement
on installing .net 3.5 runtime on his machine. But I also need to install
SQL Server CE 3.1 binaries (SQLServerCE31-EN.msi). Could anybody give me a
pointer on how to achieve this?

Regards



CSharp/C# >> VS 2005 Setup - How to add dependencies for SQL Server CE?

by Daniel Cigic » Mon, 09 Jun 2008 23:15:35 GMT


You could use CustomAction for the installer. Check MSDN for more details.

Similar Threads

1. setup Sql Server 2005 Yukon Beta & VS .Net 2005 Beta

2. VS 2005 Beta 1 and SQL Server 2005

3. VS 2005 - SQL Server 2005 Integration

4. 2005 Setup Project: Installing SQL Server Express prerequisite with command line parameters

Hi, I've got a setup project which installs SQL Server Express as a
prerequisite to my program.

The problem is that by default it's installed using the SQLEXPRESS
instance name and Windows Authentication login mode.

I'd like to have my own instance name and SQL Authentication, which is
easily achieved with command line parameters... is there a way to
specify that sort of thing?

Thanks

5. Connecting Database Engine (SQl server 2005 file .*mdf) for Win CE - CSharp/C#

6. Microsoft SQL Server 2005 Compact Edition in windows ce 6.0

hello
   I have read much about Microsoft SQL Server 2005 Compact Edition,
many delpoy always copy these files to device:
sqlce30.dev.CHS.ppc.wce5.armv4i.CABsqlce30.ppc.wce5.armv4i.CAB
sqlce30.repl.ppc.wce5.armv4i.CAB

but I think "Microsoft SQL Server 2005 Compact Edition" means sqlce3s,
and I can not find cab files in windowc ce 6.0?
   then, how can I deploy applications use Microsoft SQL Server 2005
Compact Edition in windows ce 6.0.

7. VS 2005 & .CE NET 4.20 & SQL Mobile 2005??

8. Error with DISTINCT constraint in SQL CE (not SQL CE 2005)

I am having some problems getting this query to work. When I remove the 
DISTINCT constraint the query works great but it does not produce unique 
results. When I add the DISTINCT constraint back into the query I get an SQL 
CE error telling me that a column name is invalid.

Here is the query (with the DISTINCT constraint):

sqltext = "SELECT DISTINCT PestID,Pest FROM tblPests " & _
                              "WHERE (CustomerID = " & customerid & " " & _
                              "OR CustomerID = 1) " & _
                              "AND Active='Y' " & _
                              "AND (CustomerChemicalID = " & 
spraying.chemicalid1 & " " & _
                              "OR CustomerChemicalID = " & 
spraying.chemicalid2 & " " & _
                              "OR CustomerChemicalID = " & 
spraying.chemicalid3 & ") " & _
                              "ORDER BY CustomerID DESC, Pest ASC;"

Does anyone have any suggestions on this or know what in the world that I am 
doing wrong? I am quite sure it is syntax related.

Thanks in advance,
nb


------------------------------------------
Noble D. Bell
AgForest Partners, Inc.