Re: MS SQL CE 3.5 SP1 - ClickOnce

Tech-Archive recommends: Fix windows errors by optimizing your registry



The app will be completely written in managed code, so we want to avoid
running in WoW mode.
You're response confirms to me that I'm on the right path.
I reviewed all the documentation you cited, and created a new bootstrapper
package laid out as such:

C:\Program Files\Microsoft
SDKs\Windows\v6.0A\Bootstrapper\Packages\SQLServerCE35SP1\EN
C:\Program Files\Microsoft
SDKs\Windows\v6.0A\Bootstrapper\Packages\SQLServerCE35SP1\product.xml
C:\Program Files\Microsoft
SDKs\Windows\v6.0A\Bootstrapper\Packages\SQLServerCE35SP1\EN\package.xml
C:\Program Files\Microsoft
SDKs\Windows\v6.0A\Bootstrapper\Packages\SQLServerCE35SP1\EN\ssceeula-EN.rtf
C:\Program Files\Microsoft
SDKs\Windows\v6.0A\Bootstrapper\Packages\SQLServerCE35SP1\EN\x64
C:\Program Files\Microsoft
SDKs\Windows\v6.0A\Bootstrapper\Packages\SQLServerCE35SP1\EN\x86
C:\Program Files\Microsoft
SDKs\Windows\v6.0A\Bootstrapper\Packages\SQLServerCE35SP1\EN\x64\SSCERuntime-ENU-x64.msi
C:\Program Files\Microsoft
SDKs\Windows\v6.0A\Bootstrapper\Packages\SQLServerCE35SP1\EN\x86\SSCERuntime-ENU-x86.msi

I also modified package.xml to point to the two different msi files, and now
I get all the prerequisites published to my install media, so I think I have
what I need for now.
--
- Larry


"Laxmi Narsimha Rao Oruganti [MSFT]" wrote:

Few questions before we proceed:
1) I am assuming your app is *completely* written in managed. If so, do you
want the app to run in WoW mode or MSIL?
2) If WoW, you need set the target platform of your application as "x86" (by
default it is "Any"). This way you just need to package only SQL CE v3.5
SP1 x86 MSI as the your application works in WoW mode on 64-bit Vista
3) If MSIL, SQL CE v3.5 SP1 x64 MSI is not integrated out-of-box with
ClickOnce. Unfortunately, it is not that simple to do it on your own. You
need to get expert at ClickOnce integration especially product.xml and
package.xml (under ProgramFiles\Microsoft SDKs\Windows
SDK\<Version>\Bootstrapper\Packages\). MSDN has got all the documentation
on how ClickOnce authoring can be done.

In the mean time, I will try to see if our setup dev can come with a blog on
our team blog (http://blogs.msdn.com/sqlservercompact/). But this may not
be anytime soon than 20 days as we have lot of holidays coming for India and
most of us would be disappearing:)

Thanks,
Laxmi

"lkuhn" <lkuhn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E351378B-EA8A-4282-85A0-8F0C245F9518@xxxxxxxxxxxxxxxx
Laxmi,

I need to target SQL CE 3.5 SP1 to both x86 and x64 vista.

I see that there are two separate MSIs here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=dc614aee-7e1c-4881-9c32-3a6ce53384d9&displaylang=en

Can you give me guidance on how to prepare the bootstrapper package?

- Larry

--
- Larry


"pbcoder" wrote:

Hey Laxmi,

Thx for your answer - it helped me a lot. The msi package that is located
in
the \Bootstrapper\Packages is infact SP1.

Best Regards

Lars

"Laxmi Narsimha Rao Oruganti [MSFT]" wrote:

Hey Lars,

Please refer to this blog post for the release build version of SQL
Server Compact:
http://blogs.msdn.com/sqlservercompact/archive/2008/02/08/sql-server-compact-release-versions.aspx
Then about SQL CE v3.5 SP1 release (along with VS 2008 SP1):
http://blogs.msdn.com/sqlservercompact/archive/2008/08/13/released-sql-server-compact-v3-5-sp1-sql-server-2008-rtm-visual-studio-2008-sp1-net-framework-v3-5-sp1.aspx

Now to know whether your clickonce is deploying RTM or SP1, there
are
two ways to verify yourself:
1) On a machine where your clickonce application is deployed, open
Add/Remove Programs, Scroll over and select "Microsoft SQL Server
Compact
3.5 English" OR "Microsoft SQL Server Compact 3.5 SP1 English", then
click
on "Click here for support information". On the dialog popped-up you
should
find a build version which you can compare with the above blog post to
see
which version is exactly getting deployed

2) You can MSI tools like ORCA, MSIINFO to find the version of the
SQL
CE v3.5 package which is getting embedded into your application. You
can
find the SQL CE v3.5 MSI under C:\Program Files\Microsoft
SDKs\Windows\v6.0A\Bootstrapper\Packages

This is just to help you to troubleshoot, and if you have installed
VS
2008 SP1, you will have SQL CE v3.5 SP1 deployed. If it is not
happening,
then let us know.

Thanks,
Laxmi

"pbcoder" <pbcoder@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:51C579F5-64FE-442C-80B4-F6E3A00C7F17@xxxxxxxxxxxxxxxx
I forgot it is VS 2008 SP1 that I'm using

"pbcoder" wrote:

Hi,

I have an application which is deployed using ClickOnce. Prev. I
have
used
CE 3.1 but would like to use CE 3.5 SP1 - I'm using VS 2008. When I
look
at
the prerequisites I only see sql compact 3.5 not SP1.

My Question - are the files deploy actually SP1 files or must I
deploy CE
3.5 SP1 prior to deploy a new version of my application?

Kind Regards

Lars






.



Relevant Pages

  • Re: MS SQL CE 3.5 SP1 - ClickOnce
    ... SP1 x86 MSI as the your application works in WoW mode on 64-bit Vista ... ClickOnce. ... Please refer to this blog post for the release build version of SQL ...
    (microsoft.public.sqlserver.ce)
  • Re: MS SQL CE 3.5 SP1 - ClickOnce
    ... Can you give me guidance on how to prepare the bootstrapper package? ... Now to know whether your clickonce is deploying RTM or SP1, ... Scroll over and select "Microsoft SQL Server Compact ... You can MSI tools like ORCA, MSIINFO to find the version of the SQL ...
    (microsoft.public.sqlserver.ce)
  • Re: MS SQL CE 3.5 SP1 - ClickOnce
    ... here is a blog post by my friend Manikyam Bavandla (our setup ... SP1 x86 MSI as the your application works in WoW mode on 64-bit Vista ... ClickOnce. ...
    (microsoft.public.sqlserver.ce)
  • Re: MS SQL CE 3.5 SP1 - ClickOnce
    ... Now to know whether your clickonce is deploying RTM or SP1, ... Scroll over and select "Microsoft SQL Server Compact ...
    (microsoft.public.sqlserver.ce)
  • Re: MS SQL CE 3.5 SP1 - ClickOnce
    ... Now to know whether your clickonce is deploying RTM or SP1, ... Scroll over and select "Microsoft SQL Server Compact ... You can MSI tools like ORCA, MSIINFO to find the version of the SQL ...
    (microsoft.public.sqlserver.ce)