I ended up with a custom action that both starts the instance (I have a dialog in the GUI
for a user to select from the list/drop-down box of instances available on the local
computer), connects with trusted security setting, and unloads ODS dll. It also picks the
path where to install ODS DLLs for the instance in question. A lot of work, and all has
to be done before any file copying occurs. Works fine. By starting the instance/service
in CA I also ensure that it's running when ConfigureSql is executed. So it all plays well
this way. It does uninstall correctly too. So I am now satisfied with how things are
currently.
I gave it some thought and it seems like several scenarios are possible with executing SQL
scripts during install/uninstall/upgrade. I also wonder if it would make sense to add
<Condition> as a child to <SqlString> and <SqlScript>, although this might be handled
by placing those in <Component>s and adding <Condition> to those.
Tuesday, September 20, 2005, 10:22:17 AM, you wrote:
> K and I have discussed how to get the Server CustomActions to allow their
> sequences to be overridden. I think that Feature Request is already open.
> Until that is done, you can just build a custom sca.wixlib form sources in
> wix\src\ca\serverca\setup\sca.wxs to schedule the actions where you want.
> -----Original Message-----
> From:
[hidden email]
> [mailto:
[hidden email]] On Behalf Of Alexei Boukirev
> Sent: Thursday, September 15, 2005 6:38 AM
> To:
[hidden email]
> Subject: [WiX-users] Stopping SQL service and sca.wixlib
> Hello wix-users,
> I'm working on setup that installs an extended procedures library/DLL for
> SQL Server 2000.
> I'm not so worried about initial install but rather about upgrade. I
> need to stop SQL
> Server service(s) to replace file and I cannot schedule replacement for
> next reboot as I
> have to run a specific SQL script after I replaced file (to
> load/instantiate xp_....
> procedures). It's all good to this point and <ServiceControl ...> is my
> friend. To run
> the script I was going to use <SqlScript ...> together with the rest of
> <Sql...> tags. I
> looked at sca.wixlib and was able to figure that it schedules
> ConfigureSql after
> InstallFiles (at least that's how it seems to me) in InstallExecuteSequence.
> That is long
> before StartServices. It means SQL services will be stopped at the moment.
> I could try and figure it out from C++ sources if sca custom actions
> will start SQL
> Server on demand when it'll come to executing the script. I decided to
> ask here if
> anybody knows whether it does so. Maybe someone went through the similar
> scenario and
> could help with advice.
--
Best regards,
Alexei
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play:
http://sourceforge.net/geronimo.php_______________________________________________
WiX-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/wix-users
Locked
