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
