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 <[email protected]> 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:[email protected]] > 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 <[email protected]> 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:[email protected]] >> Sent: 04 November 2014 18:33 >> To: [email protected] >> 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 >> [email protected] >> 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/wix-users > > > ------------------------------------------------------------------------------ > _______________________________________________ > WiX-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/wix-users
