Not sure that is a failure case. It would need to succeed in the case where a repair comes a long and wants to put the database back. If it is already there, no work done. Very similar to the way the Windows Installer behaves for all other resources.
-----Original Message----- From: Erdinch Akbasli [mailto:erd...@microsoft.com] Sent: Monday, January 26, 2009 09:31 To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] Create Database does NOT fail even though there is a database with the same name Hi, I have a database element which should install a database and abort if the installation fails. The component is as below. <Component Id="Database" Guid="857106E0-F1EC-42FE-965E-A098EBB06BD1" Permanent="no" NeverOverwrite="yes" > <File Id="DatabaseFile" Name="$(var.DemoDatabaseBackupFileName)" DiskId="1" Source="TempSrc\$(var.DemoDatabaseBackupFileName)" KeyPath="yes" /> <sql:SqlDatabase Id="CreateDemoDatabase" Database="$(var.DatabaseName)" Server="[ComputerName]" Instance="[INSTANCENAME]" CreateOnInstall="yes" CreateOnReinstall="yes" ConfirmOverwrite="no" DropOnUninstall="no" ContinueOnError="no" DropOnInstall="no" DropOnReinstall="no"> </sql:SqlDatabase> </Component> To test, I already have a database with the same name on the server. So I would expect this action to fail and stop the setup. I looked around the documentation but couldn’t find anything on the behaviour so I’m not sure if this is a bug or not. In the verbose log file I get the below message on CreateDatabase, the Return value is 1. Shouldn’t the installer fail complaining about the database already exists? MSI (s) (64!18) [17:52:46:076]: PROPERTY CHANGE: Adding CreateDatabase property. Its value is 'CreateDemoDatabaseERDINA-WSDemo Database NAV (6-0)97100'. MSI (s) (64!18) [17:52:46:076]: Creating MSIHANDLE (887) of type 790531 for thread 2328 MSI (s) (64!18) [17:52:46:077]: Closing MSIHANDLE (887) of type 790531 for thread 2328 MSI (s) (64!18) [17:52:46:077]: Doing action: CreateDatabase Action start 17:52:46: CreateDatabase. Action ended 17:52:46: CreateDatabase. Return value 1. MSI (s) (64!18) [17:52:46:080]: Closing MSIHANDLE (871) of type 790541 for thread 2328 MSI (s) (64:F0) [17:52:46:081]: Closing MSIHANDLE (870) of type 790542 for thread 5576 Action ended 17:52:46: InstallSqlData. Return value 1. Am I missing something here, version of WIX is 3.0.4805.0? Thx, /E ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
