HI, Thanks for your help. It worked for me, Thanks a lot.
-----Original Message----- From: Bala [mailto:balakrish...@ameexusa.com] Sent: 05 November 2014 01:19 To: General discussion about the WiX toolset. Subject: Re: [WiX-users] Incorrect syntax near 'DATABASE' while Uninstalling from AddRemoveProgram Thanks for your suggestion I will try and update you. Thanks Bala Sent from Samsung Mobile. -------- Original message -------- From: John Cooper <jocoo...@jackhenry.com> Date:05/11/2014 1:16 AM (GMT+05:30) To: "General discussion about the WiX toolset." <wix-users@lists.sourceforge.net> Cc: Subject: Re: [WiX-users] Incorrect syntax near 'DATABASE' while Uninstalling from AddRemoveProgram Is the database name passed in as a property? If this is the case, the property won't be automatically persisted without something like the "remember pattern" which would give you the missing database> http://robmensching.com/blog/posts/2010/5/2/the-wix-toolsets-remember-proper ty-pattern/ -- John Merryweather Cooper Senior Software Engineer | Enterprise Service Applications | Continuing Development Jack Henry & Associates, Inc.R | Lenexa, KS 66214 | Ext: 431050 |jocoo...@jackhenry.com -----Original Message----- From: Bala [mailto:balakrish...@ameexusa.com] Sent: Tuesday, November 4, 2014 1:22 PM To: General discussion about the WiX toolset. Subject: Re: [WiX-users] Incorrect syntax near 'DATABASE' while Uninstalling from AddRemoveProgram Hi, There is no syntax error in sql. but the database name not included in the script. that is the reason it throws like incorrect syntax. The actual sql script comes like "Drop database " Thanks Bala Sent from Samsung Mobile. -------- Original message -------- From: Phil Wilson <phildgwil...@gmail.com> Date:05/11/2014 12:04 AM (GMT+05:30) To: "General discussion about the WiX toolset." <wix-users@lists.sourceforge.net> Cc: Subject: Re: [WiX-users] Incorrect syntax near 'DATABASE' while Uninstalling from AddRemoveProgram The error is reported as a syntax error according to those messages, so why not investigate that possibility? That your SQL is incorrect? If you really did this: " If manually deleted the Registry entry for add/remove program and delete the installer files after that Installed again and uninstalled it" then you may have damaged that system. You can't make the system look like the product is uninstalled by just deleting the ARP data and installer files. --------------- Phil Wilson On Tue, Nov 4, 2014 at 9:48 AM, Bala <balakrish...@ameexusa.com> wrote: > Yes, > > Created the database with the installer while installing. > I want to delete the database while uninstalling. > > Thanks > Bala. > > -----Original Message----- > From: Jeremiahf [mailto:jeremi...@gmail.com] > Sent: 04 November 2014 22:15 > To: General discussion about the WiX toolset. > Subject: Re: [WiX-users] Incorrect syntax near 'DATABASE' while > Uninstalling from AddRemoveProgram > > Are you creating the database with the installer? > > On Tue, Nov 4, 2014 at 7:21 AM, Bala <balakrish...@ameexusa.com> wrote: > >> HI All, >> >> >> >> The exact error in log file >> >> >> >> Error 26202. Error -2147217900: failed to drop SQL database: , error >> detail: >> Incorrect syntax near 'DATABASE'.. >> >> >> >> If manually deleted the Registry entry for add/remove program and >> delete the installer files after that Installed again and uninstalled >> it is not throwing error also not deleting the database. >> >> >> >> Checked with SQL profiles for the query. >> >> >> >> "Drop DATABASE " >> >> >> >> >> >> I need to fix the issue. >> >> >> >> Help me . >> >> >> >> Thanks >> >> Bala >> >> >> >> >> >> >> >> From: Bala [mailto:balakrish...@ameexusa.com] >> Sent: 04 November 2014 18:33 >> To: WiX-users@lists.sourceforge.net >> Subject: Incorrect syntax near 'DATABASE' while Uninstalling from >> AddRemoveProgram >> >> >> >> HI, >> >> >> >> While uninstalling a WIX installation from Add/Remove program it >> throws error like "Error 26202. Error -2147217900: failed to drop SQL >> database: , error detail: Incorrect syntax near 'DATABASE'. >> >> Analyzed further through SQL profiles and found that the DATABASE >> name comes as empty. >> >> >> >> Please help me how to fix this issue. >> >> >> >> Thanks >> >> Bala. >> >> >> >> >> >> >> >> >> --------------------------------------------------------------------- >> - >> -------- _______________________________________________ >> WiX-users mailing list >> WiX-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/wix-users >> > > > > -- > "They may forget what you said but they will never forget how you made > them feel." -- Anonymous > ---------------------------------------------------------------------- > ------ > -- > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > ---------------------------------------------------------------------- > -------- _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users ---------------------------------------------------------------------------- -- _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ---------------------------------------------------------------------------- -- _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. ---------------------------------------------------------------------------- -- _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ---------------------------------------------------------------------------- -- _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
