Thanks Amy and Bob for response, I was able to get it working by setting the values from registery . Though the suggestion from BOB(In one of the reply to this post) Reading and writing to Registry should be done without CA looks to be better. I have not tried this yet though.
Jai Jai, I think I am having a similar issue. I am going to test not changing the database name in my install from the default and see if it still drops correctly to confirm, but definitely if I change the name it does not drop the database or the login I create on the server. Amy -----Original Message----- From: siaj [mailto:meabrakada...@gmail.com] Sent: Tuesday, December 16, 2008 10:24 PM To: wix-d...@lists.sourceforge.net; wix-users@lists.sourceforge.net Subject: [WiX-users] Unistall script getting executed only on the defaultdatabase Hello, I am creating a setup using Wix which is creating some objects in a database and droping it while uninstall. The create and drop is working fine but if the user chooses to create these objects on a different database while installation,the uninstall is not cleaning it while uninstall. I tried to set the properties from Registery values using custom action (during uninstall) and sequenced it before AppSearch. I can see the custom action getting called (I used a message box) but the drop script is getting fired only the default database. so If components were created on new database, it never gets dropped. The default property "DatabaseName" is getting <Property Id='MECDATABASE' Value='Reporting_Database'/> <Property Id= DBSERVERNAME Value='Reporting_Server'/> <Sql:SqlDatabase Id="ReportingDatabase" Database="[RPTDATABASE]" CreateOnInstall="yes" CreateOnUninstall="no" DropOnInstall="no" Server=" [DBSERVERNAME]" ContinueOnError="yes" DropOnUninstall="no"> <Sql:SqlScript Id="S1" ExecuteOnInstall="yes" ExecuteOnReinstall="yes" ContinueOnError="no" Sequence="001" BinaryKey="OLAP_Scripts_Install.sql" <Sql:SqlScript Id="S2" ExecuteOnInstall="no" ExecuteOnReinstall="no" ExecuteOnUninstall="yes" ContinueOnError="yes" Sequence="002" BinaryKey=" OLAP_Scripts_Uninstall.sql"/> </Sql:SqlDatabase> <Custom Action="SetVariablesFromReg" Before="AppSearch"><![CDATA[Installed ]]></Custom> Please let me know if you have seen this issue or have any feedback. Thanks, Jai ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
