Hi,
I'm a complete newbie to Wix and have been trying to use the SQL Database
functionality of the suite. First of all I've been trying to get the SQL
sample in the Wix tutorial to work
(http://www.tramontana.co.hu/wix/lesson7.php) but I'm not even having any
luck doing that.
I'm able to create the msi file but when I actually go to run the install
the install runs through but nothing happens - no database is created. I've
tried running the install with a verbose log but I can't see any clues in
the log. In fact the ConfigureSQL action returns with value 1. I've tried
various combinations of user/server name but I thought that the install
would fail and rollback if it couldn't find the server or couldn't
authenticate the user but it just doesn't seem to do anything at all. (I'm
using SQL 2005 Express).
My SQLComponent declaration is as follows:
<Component Id='SqlComponent' Guid='01CC8D91-BA0A-48BD-A483-0B745A3FB724'>
<SqlDatabase Id='SqlDatabase' Database='Foobar'
Server='(local)\SQLEXPRESS'
CreateOnInstall='yes' DropOnUninstall='yes'
ContinueOnError='no>
<SqlScript Id='CreateTable' BinaryKey='CreateTable'
ExecuteOnInstall='yes' />
</SqlDatabase>
</Component>
and here's part of my log file:
MSI (s) (A4:40) [22:08:52:343]: Doing action: ConfigureSql
Action start 22:08:52: ConfigureSql.
MSI (s) (A4:08) [22:08:52:359]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI49.tmp, Entrypoint: ConfigureSql
MSI (s) (A4:EC) [22:08:52:359]: Generating random cookie.
MSI (s) (A4:EC) [22:08:52:359]: Created Custom Action Server with PID 1024
(0x400).
MSI (s) (A4:48) [22:08:52:406]: Running as a service.
MSI (s) (A4:48) [22:08:52:406]: Hello, I'm your 32bit Impersonated custom
action server.
Action ended 22:08:52: ConfigureSql. Return value 1.
I'm totally stumped. Any help would be greatly appreciated.
Graham
_________________________________________________________________
Get Hotmail, News, Sport and Entertainment from MSN on your mobile.
http://www.msn.txt4content.com/
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
