Re: [WiX-users] Unable to execute SQL script from patch

2011-08-01 Thread Peter Shirtcliffe
--Original Message- From: Nangai [mailto:thangananga...@iinterchange.com] Sent: 30 July 2011 06:36 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Unable to execute SQL script from patch My script contains single line query to drop an existing table. This is not complex query. I thi

Re: [WiX-users] Unable to execute SQL script from patch

2011-07-29 Thread Nangai
My script contains single line query to drop an existing table. This is not complex query. I think wix not supporting database script patch -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-SQL-script-from-patch-tp6593861p6635633.html

Re: [WiX-users] Unable to execute SQL script from patch

2011-07-28 Thread Peter Shirtcliffe
-users] Unable to execute SQL script from patch Yes. Verbose log message shows that the component is installed. I have no idea to solve this problem. >From verbose log: MSI (s) (54:D4) [12:59:25:411]: Component: ProductComponent; Installed: Local; Request: Local; Action: Local; Client St

Re: [WiX-users] Unable to execute SQL script from patch

2011-07-28 Thread Nangai
Yes. Verbose log message shows that the component is installed. I have no idea to solve this problem. >From verbose log: MSI (s) (54:D4) [12:59:25:411]: Component: ProductComponent; Installed: Local; Request: Local; Action: Local; Client State: Local -- View this message in context: http:

Re: [WiX-users] Unable to execute SQL script from patch

2011-07-27 Thread Peter Shirtcliffe
I haven't used the SQL custom actions. Have you tried generating a verbose installation log ? -Original Message- From: Nangai [mailto:thangananga...@iinterchange.com] Sent: 27 July 2011 12:44 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Unable to execute SQL script

Re: [WiX-users] Unable to execute SQL script from patch

2011-07-27 Thread Nangai
No. It is available in the base installer itself. I cant event execute the sql script while installing the patch. I tried with sql string also. It is not working. -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-SQL-script-from-patch

Re: [WiX-users] Unable to execute SQL script from patch

2011-07-18 Thread Peter Shirtcliffe
Is the SQL script present only in the patch that is being removed ? If so, it won't work because the script is not visible to the installer when it is being uninstalled. There's more information about it, including workarounds, here http://msdn.microsoft.com/en-us/library/aa370739%28v=vs.85%29.aspx

Re: [WiX-users] Unable to execute SQL script from patch msp

2011-05-26 Thread Blair
Explain "not included in the patch", because I have three very different ideas that you could be referring to. 1) Is this based on opening the MSP file in Orca? 2) Was there an error when applying the patch to an already installed product? 3) Are you referring to running SQL against the MSP file i