Another question here ---
I need the application to be reinstalled but not the database. The
CreateOnReinstall has already been set to NO, see my code below
<SqlDatabase Id="SqlDatabase" Database="master" Server="[ComputerName]"
Instance = '[SQLINSTANCE]' ConfirmOverwrite = "yes" CreateOnReinstall="no"
CreateOnInstall="yes" DropOnUninstall="no" ContinueOnError="yes">
<SqlScript Id="CreateDB" BinaryKey="CreateDB" ExecuteOnReinstall=
"no" ExecuteOnInstall="yes" Sequence="1" /> <SqlScript
Id="CreateSQLLogin" BinaryKey="CreateSQLLogin" ExecuteOnReinstall= "no"
ExecuteOnInstall="yes" Sequence="2" /> <SqlScript Id="CreateTable"
BinaryKey="CreateTable" ExecuteOnReinstall= "no" ExecuteOnInstall="yes"
Sequence="3" /> <SqlScript Id="StoredPrec" BinaryKey="StoredPrec"
ExecuteOnReinstall= "no" ExecuteOnInstall="yes" Sequence="4" />
<SqlScript Id="GrantAccess" BinaryKey="GrantAccess" ExecuteOnReinstall= "no"
ExecuteOnInstall="yes" Sequence="5" /> <SqlScript Id="Initialize"
BinaryKey="Initialize" ExecuteOnReinstall= "no" ExecuteOnInstall="yes"
Sequence="6" />
</SqlDatabase>
But it still complains during the SQL Script execution : "Error -2147217900":
failed to execute SQL string, error detail: Database 'SYSQ' already exists.
Choose a different database name., SQL key: CreateDB SQL string: DECLARE
@SmoRoot NVARCHAR(512) EXEC[master].[dob].[xp_instance_regread]
N'HKEY_LOCAL_MACHINE', ...\SYSQ_log.ldf',S..."
Any ideas?
Anna
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
_________________________________________________________________
Telly addicts unite!
http://www.searchgamesbox.com/tvtown.shtml-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
