WiX v3.4311.0 is 6-months old. There have been a lot of fixes made in that time. Try a more recent build and see if this is fixed.
Also, make sure in a verbose log file that the Component that contains the SqlScript in question is actually being uninstalled. -----Original Message----- From: anwesha.m [mailto:anwesh...@live.com] Sent: Monday, January 12, 2009 03:58 To: wix-users@lists.sourceforge.net Subject: [WiX-users] Sql scripts do not run at the time of uninstallation Hi All, I am using Wix 3.0.4311.0. I have an installer which is required to run a script at the time of installation (to create stored procedures in database) and run another script at the time of uninstallation (to drop the stored procedures created). Here's a snippet of the code: <sql:SqlScript Id="SQLScript1" BinaryKey="DeleteScript" ExecuteOnInstall="no" RollbackOnInstall="yes" ContinueOnError="no" ExecuteOnUninstall="yes" Sequence="1" /> <sql:SqlScript Id="SQLScript2" BinaryKey="CreateScript" ExecuteOnInstall="yes" RollbackOnInstall="yes" ContinueOnError="no" ExecuteOnUninstall="no" Sequence="1" /> At the time of uninstallation, the 'DeleteScript' is not getting executed and the stored procedures do not get dropped. This the part of the log file: MSI (s) (E4:18) [03:31:49:741]: Doing action: UninstallSqlData Action ended 3:31:49: RemoveDuplicateFiles. Return value 1. MSI (s) (E4:58) [03:31:49:756]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSIB1.tmp, Entrypoint: UninstallSqlData MSI (s) (E4:04) [03:31:49:756]: Generating random cookie. MSI (s) (E4:04) [03:31:49:772]: Created Custom Action Server with PID 8492 (0x212C). MSI (s) (E4:44) [03:31:49:819]: Running as a service. MSI (s) (E4:44) [03:31:49:819]: Hello, I'm your 32bit Impersonated custom action server. MSI (s) (E4!CC) [03:31:49:944]: PROPERTY CHANGE: Adding RollbackExecuteSqlStrings property. Its value is 'SQLDB321SQLScript111 the body of the script goes here Action start 3:31:49: UninstallSqlData. MSI (s) (E4!CC) [03:31:49:944]: Doing action: RollbackExecuteSqlStrings Action start 3:31:49: RollbackExecuteSqlStrings. Action ended 3:31:49: RollbackExecuteSqlStrings. Return value 1. Actually I have upgraded the installer from Wix 2.0 to wix 3.0. The same code in wix 2.0 works perfect. It installs and uninstalls the database objects as required. But, in wix 3.0 , the uninstall script does not run. What am i missing here? What else needs to be done for wix 3? Thanks in advance, Anwesha -- View this message in context: http://n2.nabble.com/Sql-scripts-do-not-run-at-the-time-of-uninstallation-tp2145283p2145283.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Check out the new SourceForge.net Marketplace. It is the best place to buy or sell services for just about anything Open Source. http://p.sf.net/sfu/Xq1LFB _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Check out the new SourceForge.net Marketplace. It is the best place to buy or sell services for just about anything Open Source. http://p.sf.net/sfu/Xq1LFB _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
