[WiX-users] Create Database does NOT fail even though there is a database with the same name

[Erdinch Akbasli]

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 'CreateDemoDatabase€ERDINA-WS€€Demo Database NAV 
(6-0)€97€1€€€0€0'.
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