Bob Arnson <b...@joyofsetup.com> Wrote:
>Dane Anderson (Volt) wrote:
>> I am trying to use the Certificate element to install a certificate file
>> (.pfx). The problem is
>> that Wix barfs on it.
>> When I try building the MSI, I get a message about the Certificate element
>> being unexpected. The
>> Sourceforge
>> documentation
>> (http://wix.sourceforge.net/manual-wix2/wix_xsd_certificate.htm) indicates
>> that it
>> can
>> be the child of a Component or an Include element.
>
> Which version of WiX are you using?
WiX 3.0.3412.0 (according to the documentation that was installed with it)
------------------------------
Message: 8
Date: Tue, 17 Feb 2009 15:26:03 +1300
From: Joe Osman <joe.os...@tait.co.nz>
Subject: Re: [WiX-users] sql:SqlDatabase drops database on major
upgrade
To: "General discussion for Windows Installer XML
toolset."<wix-users@lists.sourceforge.net>
Message-ID: <499a203b.7000...@tait.co.nz>
Content-Type: text/plain; charset="iso-8859-1"
Hi Michael,
In your answer are you referring to WIX V2 or WIX V3?
I am using V3 and when I tried to reschedule the custom action
DeleteExistingProduct I got the error message: Unresolved reference to
symbol 'CustomAction:DeleteExistingProduct' .
In your second comment you are saying that the script should run on
ExecuteOnUninstall. Based on your suggestion I've created the following
sql script:
USE [master]
GO
IF ('[REMOVE]' = 'ALL')
BEGIN
DROP DATABASE MyDataBase
END
but the database doesn't get removed on uninstall. How can the sql
script determine the value of [REMOVE] on uninstall?
Thank you.
Michael Osmond wrote:
> Hello Joe,
>
> I've been in a similar situation. The possible solutions I am aware of:
>
> 1. If you schedule the DeleteExistingProduct action at the end of the
> install (I think after the InstallFinalise), my understanding is that
> the install should calculate that there still is a count of one on the
> database component and not remove it. For other reasons I don't use
> this with mine.
>
> 2. Don't use the DropOnUnistall. Set the database as CreateOnInstall=y
> ContinueOnError=y and then have an SQL Script that is set to run
> ExecuteOnUninstall that drops the database. You could then put an MSI
> condition into the script eg: IF ('[REMOVE]' = 'ALL') drop database
> [DBNAME]. It gives you a little more control.
>
> For the books. Because of the nature of data in our server application,
> our uninstall does not delete the database at all, the user must
> manually (and hence knowingly) drop the database.
>
> PS: Something to check. Test what happens if there is a rollback
> during (or after) the SQL Install. My experience was that the rollback
> (because this is technically an install of a new database component)
> would do the rollback by droping the database. (I am still on WIX V2
> and have a slightly modified version of the SQL Custom Actions).
>
> Mihael
>
> -----Original Message-----
> From: Joe Osman [mailto:joe.os...@tait.co.nz]
> Sent: Monday, 16 February 2009 12:14 PM
> To: General discussion for Windows Installer XMLtoolset.
> Subject: [WiX-users] sql:SqlDatabase drops database on major upgrade
>
> I want to have my database dropped only during uninstall and to do that
> I am using sql:SqlDatabase element. The problem is that the database is
> dropped during a major upgrade. How can I prevent it from happening?
>
> Here is the command I am using:
> <Component Id="KmfDatabase"
> Guid="{82B345FC-A889-44c2-A964-DE2495DC0D29}">
> <sql:SqlDatabase Id="TaitKmf" Database="TaitKmf"
> ContinueOnError="yes" CreateOnReinstall="no" CreateOnUninstall="no"
> CreateOnInstall="no"
> DropOnReinstall="no" DropOnUninstall="yes" DropOnInstall="no"
> Server="[ComputerName]"/>
> </Component>
>
> =======================================================================
> This email, including any attachments, is only for the intended
> addressee. It is subject to copyright, is confidential and may be the
> subject of legal or other privilege, none of which is waived or lost by
> reason of this transmission.
> If the receiver is not the intended addressee, please accept our
> apologies, notify us by return, delete all copies and perform no other
> act on the email.
> Unfortunately, we cannot warrant that the email has not been altered or
> corrupted during transmission.
> =======================================================================
>
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
> -Strategies to boost innovation and cut costs with open source participation
> -Receive a $600 discount off the registration fee with the source code: SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> WiX-users mailing list
> WiX-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wix-users
>
>
=======================================================================
This email, including any attachments, is only for the intended
addressee. It is subject to copyright, is confidential and may be
the subject of legal or other privilege, none of which is waived or
lost by reason of this transmission.
If the receiver is not the intended addressee, please accept our
apologies, notify us by return, delete all copies and perform no
other act on the email.
Unfortunately, we cannot warrant that the email has not been
altered or corrupted during transmission.
=======================================================================
------------------------------
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
------------------------------
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
End of WiX-users Digest, Vol 33, Issue 85
*****************************************
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
