For the error case: does your database name start with a single quote? Is that even allowed?
I suggest using the SQL Profiler and see why the database isn't getting dropped. Almost always it ends up being something else in the environment. -----Original Message----- From: Arthur Curvello [mailto:arthur.curve...@conv.com.br] Sent: Monday, February 09, 2009 10:33 To: 'General discussion for Windows Installer XML toolset.' Subject: Re: [WiX-users] Problems Droping Databases LOG file MSI (s) (4C!60) [16:21:26:734]: PROPERTY CHANGE: Modifying DropDatabase property. Its current value is 'DropDBNameDatabase€(local)\sqlexpress€€AnotherDB€8€1€€'. Its new value: 'DropGuidDatabase€(local)\sqlexpress€€[d1b5467c-77af-461c-9e79-9a29171e5cda] €10€1€€'. MSI (s) (4C!60) [16:21:26:734]: Doing action: DropDatabase Ação 16:21:26: DropDatabase. Excluindo Bases de Dados Ação iniciada 16:21:26: DropDatabase. 1: Excluindo Bases de Dados Ação concluída 16:21:26: DropDatabase. Valor de retorno 1. Seems to work ok for the installer, but the guiddb is not dropped in sql. Correcting last post: I wrote: <Property Id="GUIDDB">'d1b5467c-77af-461c-9e79-9a29171e5cda'</Property> No error but do not drop its wrong, I can just compile, but I got error installing: Incorrect syntax near 'd1b5467c'. bug? Thanx, Arthur Curvello arthur.curve...@conv.com.br tel +55 21 2494-5476 cel +55 21 9762-4284 Confidencialidade: A informação contida nesta mensagem de e-mail, incluindo quaisquer anexos, é confidencial e está reservada apenas à pessoa ou entidade para a qual foi endereçada. Se você não é o destinatário ou a pessoa responsável por encaminhar esta mensagem ao destinatário, você está, por meio desta, notificado que não deverá rever, retransmitir, imprimir, copiar, usar ou distribuir esta mensagem de e-mail ou quaisquer anexos. Caso você tenha recebido esta mensagem por engano, por favor, contate o remetente imediatamente e apague esta mensagem de seu computador ou de qualquer outro banco de dados. Grato. Confidentiality Notice: The information contained in this email message, including any attachment, is confidential and is intended only for the person or entity to which it is addressed. If you are neither the intended recipient nor the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that you may not review, retransmit, convert to hard copy, copy, use or distribute this email message or any attachments to it. If you have received this email in error, please contact the sender immediately and delete this message from any computer or other data bank. Thank you. -----Original Message----- From: Rob Mensching [mailto:rob.mensch...@microsoft.com] Sent: Monday, February 09, 2009 3:16 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Problems Droping Databases Need more details. What does the verbose log file show? -----Original Message----- From: Arthur Curvello [mailto:arthur.curve...@conv.com.br] Sent: Monday, February 09, 2009 07:07 To: wix-users@lists.sourceforge.net Subject: [WiX-users] Problems Droping Databases Can't drop a database guid named like: D33B2FD0-C0BF-4d39-B9D4-DB9ED0B880F0 Tried : <Property Id="GUIDDB">d1b5467c-77af-461c-9e79-9a29171e5cda</Property> I got Error in syntanx near - <Property Id="GUIDDB">[d1b5467c-77af-461c-9e79-9a29171e5cda]</Property> No error but do not drop <Property Id="GUIDDB">'d1b5467c-77af-461c-9e79-9a29171e5cda'</Property> No error but do not drop <Property Id="GUIDDB">[/[]d1b5467c-77af-461c-9e79-9a29171e5cda[/]]</Property> No error but do not drop <Sql:SqlDatabase Id="DropGuidDatabase" Database="[GUIDDB]" Server="[SERVERNAME]" DropOnInstall="yes" DropOnUninstall="yes"/> This database is not created by the setup, I just want to delete it when upgrading and unistalling, its "application's trash". Any help? Thanx, Arthur Curvello Confidencialidade: A informação contida nesta mensagem de e-mail, incluindo quaisquer anexos, é confidencial e está reservada apenas à pessoa ou entidade para a qual foi endereçada. Se você não é o destinatário ou a pessoa responsável por encaminhar esta mensagem ao destinatário, você está, por meio desta, notificado que não deverá rever, retransmitir, imprimir, copiar, usar ou distribuir esta mensagem de e-mail ou quaisquer anexos. Caso você tenha recebido esta mensagem por engano, por favor, contate o remetente imediatamente e apague esta mensagem de seu computador ou de qualquer outro banco de dados. Grato. Confidentiality Notice: The information contained in this email message, including any attachment, is confidential and is intended only for the person or entity to which it is addressed. If you are neither the intended recipient nor the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that you may not review, retransmit, convert to hard copy, copy, use or distribute this email message or any attachments to it. If you have received this email in error, please contact the sender immediately and delete this message from any computer or other data bank. Thank you. ---------------------------------------------------------------------------- -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ---------------------------------------------------------------------------- -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
