Re: [WiX-users] Unable to execute SQL script from patch
I'm not really sure then, so this is just guesswork.. Has the key path of the component containing the SQL script changed ? Once the component is installed, I think the script won't run again unless the component has to be reinstalled for some reason, such as a keypath change. -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 think wix not supporting database script patch -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execu te-SQL-script-from-patch-tp6593861p6635633.html Sent from the wix-users mailing list archive at Nabble.com. - - Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users SDL PLC confidential, all rights reserved. If you are not the intended recipient of this mail SDL requests and requires that you delete it without acting upon or copying any of its contents, and we further request that you advise us. SDL PLC is a public limited company registered in England and Wales. Registered number: 02675207. Registered address: Globe House, Clivemont Road, Maidenhead, Berkshire SL6 7DY, UK. -- Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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 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 Sent from the wix-users mailing list archive at Nabble.com. -- Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Unable to execute SQL script from patch
There could be something wrong with your sql script. Try replacing the script with the simplest possible SQL statement and install that. -Original Message- From: Nangai [mailto:thangananga...@iinterchange.com] Sent: 28 July 2011 13:38 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-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 State: Local -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execu te-SQL-script-from-patch-tp6593861p6629698.html Sent from the wix-users mailing list archive at Nabble.com. - - Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users SDL PLC confidential, all rights reserved. If you are not the intended recipient of this mail SDL requests and requires that you delete it without acting upon or copying any of its contents, and we further request that you advise us. SDL PLC is a public limited company registered in England and Wales. Registered number: 02675207. Registered address: Globe House, Clivemont Road, Maidenhead, Berkshire SL6 7DY, UK. -- Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-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 State: Local -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-SQL-script-from-patch-tp6593861p6629698.html Sent from the wix-users mailing list archive at Nabble.com. -- Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Unable to execute SQL script from patch
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 from patch 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-execu te-SQL-script-from-patch-tp6593861p6625807.html Sent from the wix-users mailing list archive at Nabble.com. - - Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users SDL PLC confidential, all rights reserved. If you are not the intended recipient of this mail SDL requests and requires that you delete it without acting upon or copying any of its contents, and we further request that you advise us. SDL PLC is a public limited company registered in England and Wales. Registered number: 02675207. Registered address: Globe House, Clivemont Road, Maidenhead, Berkshire SL6 7DY, UK. -- Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Unable to execute SQL script from patch
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-tp6593861p6625807.html Sent from the wix-users mailing list archive at Nabble.com. -- Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Unable to execute SQL script from patch
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 -Original Message- From: Nangai [mailto:thangananga...@iinterchange.com] Sent: 18 July 2011 09:28 To: wix-users@lists.sourceforge.net Subject: [WiX-users] Unable to execute SQL script from patch Hi, I am unable to execute sql script while uninstalling the patch. I am using visual studio development environment to create installer setup and manually update to make it compatible with wix and create patch. I am importing custom actions from sqlextension class. but could not be able to run sql script from patch install and uninstall. Any help will be appreciated. I am using wix3.5 -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execu te-SQL-script-from-patch-tp6593861p6593861.html Sent from the wix-users mailing list archive at Nabble.com. - - AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users SDL PLC confidential, all rights reserved. If you are not the intended recipient of this mail SDL requests and requires that you delete it without acting upon or copying any of its contents, and we further request that you advise us. SDL PLC is a public limited company registered in England and Wales. Registered number: 02675207. Registered address: Globe House, Clivemont Road, Maidenhead, Berkshire SL6 7DY, UK. -- AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Unable to execute SQL script from patch
Hi, I am unable to execute sql script while uninstalling the patch. I am using visual studio development environment to create installer setup and manually update to make it compatible with wix and create patch. I am importing custom actions from sqlextension class. but could not be able to run sql script from patch install and uninstall. Any help will be appreciated. I am using wix3.5 -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-SQL-script-from-patch-tp6593861p6593861.html Sent from the wix-users mailing list archive at Nabble.com. -- AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Unable to execute SQL script from patch msp
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 itself? -Blair -Original Message- From: Nangai [mailto:thangananga...@iinterchange.com] Sent: Thursday, May 26, 2011 5:04 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Unable to execute SQL script from patch msp Hi, I am using Wix 3.5.2519.0 to create patch. I am unable to execute SQL script from patch. I am adding reference to the binaty stream of SQL file in patch. But the binary is not included in the patch. Thanks in advance. -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-exec ute-SQL-script-from-patch-msp-tp6406736p6406736.html Sent from the wix-users mailing list archive at Nabble.com. -- vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Unable to execute SQL script from patch msp
Hi, I am using Wix 3.5.2519.0 to create patch. I am unable to execute SQL script from patch. I am adding reference to the binaty stream of SQL file in patch. But the binary is not included in the patch. Thanks in advance. -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-SQL-script-from-patch-msp-tp6406736p6406736.html Sent from the wix-users mailing list archive at Nabble.com. -- vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users