Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Thomas Due
This one triggered me: This way I can pass username information into the SQL script as an MSI property. How do you do that? That is something I find could be very very useful to me, not only username information, but all sorts of information that could be useful during database creation, or

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Michael Osmond
Here's an example of how I create the user login for a database depending if the database is on the same server as the web application or a different server Some of the security stored procs I am using are obsolete in SQL2008 though (this was built for SQL2000) SqlDatabase Id=DBSQL1

[WiX-users] How to convert properties to actual values

2009-10-07 Thread Mazin Sayid Ali
Hi I'm creating a custom action that reads values from a custom table. I want to specify a filename as we do in xmlconfig using [#foo.txt] or using properties [INSTALLDIR]foo.txt. I'm using DTF to create the Custom Action. How can I parse the value from the custom table to get the Final full

[WiX-users] Test sql connection

2009-10-07 Thread Selvakumar B
how can I test sql server connection before installation? = server :___ O win mode O sql mode user :__ pass:__ --- | Test Button | --- = Regards, Selvakumar B

[WiX-users] Patch for specific files?

2009-10-07 Thread Sunkesula, Srivardhan
Can we create a Patch for the specific set of files? There might be lot of files changed. But I need Patch only for a specific component. Can I do it? Thanks Regards, Srivardhan. -- Come build with us! The

[WiX-users] Problem with decompilation using dark.exe

2009-10-07 Thread Bojan Ivanovic
Hello Community, I am trying to decompile an msi build with visual studio 2008 - team edition, using dark.exe. The command I am running is as follows: dark.exe -x . -v -o product.wxs Presentations.Setup.msi The output that I get is below: Microsoft (R) Windows Installer Xml Decompiler version

Re: [WiX-users] Unable to use Xpath expressions

2009-10-07 Thread Pan.Pantziarka
Thanks, that did the trick OK. -Original Message- From: Blair [mailto:os...@live.com] Sent: 06 October 2009 22:45 To: 'General discussion for Windows Installer XML toolset.' Subject: Re: [WiX-users] Unable to use Xpath expressions XMLFile uses the msxml3 engine that was released before

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Thomas Due
Cool, thanks. /Thomas -Original Message- From: Michael Osmond [mailto:mosm...@baytech.com.au] Sent: 7. oktober 2009 08:11 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQLServer Users/Logins Here's an example of how I create the user

[WiX-users] Correct way to sync between ComboBox with EditBox on same screen

2009-10-07 Thread Dominique Louis
Hi all, I have a custom dialog that lists all the SQLServer database instances on the network which take the form [MachineName]\[SqlInstance] in the dropdown. On the same form I have a edit box which will hold the full connection string. What do I need to do so that when the user selects

Re: [WiX-users] Unable to use Xpath expressions

2009-10-07 Thread Pan.Pantziarka
As an aside, is it better to use XmlConfig? Does that use Xpath by default? Thanks. Pan -Original Message- From: Blair [mailto:os...@live.com] Sent: 06 October 2009 22:45 To: 'General discussion for Windows Installer XML toolset.' Subject: Re: [WiX-users] Unable to use Xpath

Re: [WiX-users] WiX-users Digest, Vol 40, Issue 129

2009-10-07 Thread Simon Topley
Thanks for the reply Phil, Sorry did reply sooner I missed your reply, I assumed my message went missing. It seems that the service I am attempting to start expect an event source to be created before it will run - another issue I'm having with WIX 2.0, I can't set an event source up. The error

[WiX-users] Removing folders that don't exist at the compiling time

2009-10-07 Thread Eduard Zaverukha
Hello How I can remove a folder Logs both all enclosed files and folders? For a moment of compilation i don't know names of files and a folders containing in a folder Logs. -- Come build with us! The BlackBerry(R)

Re: [WiX-users] WiX-users Digest, Vol 40, Issue 129

2009-10-07 Thread Simon Topley
...however i still seem to have an issue on vista: StartServices: Service: ISRM_S Error 1920. Service 'ISRM_S' (ISRM_S) failed to start. Verify that you have sufficient privileges to start system services. MSI (s) (7C:AC) [07:56:43:674]: I/O on thread 4088 could not be cancelled. Error: 1168 MSI

Re: [WiX-users] Removing folders that don't exist at the compiling time

2009-10-07 Thread Rob Hamflett
If you know the format then of the name then you can do something like this: Directory Id=Log Name=Log Component Id=remLogFiles Guid=GUID_HERE RemoveFile Id=remLogFiles Name=sndbs*.log LongName=sndbs-??-??.log On=uninstall / /Component Component Id=remLogFolder Guid=GUID_HERE

Re: [WiX-users] Removing folders that don't exist at the compiling time

2009-10-07 Thread Pally Sandher
Directory Id=Logs Name=Logs Component Id=DeleteLogs DiskId=1 Guid=PUT-GUID-HERE RemoveFile Id=DeleteLogs Name=* On=both/ RemoveFolder Id=DeleteLogsDir On=both/ /Component /Directory Works for me. Remember to add the Component to a Feature it should

[WiX-users] Uninstall deleting config file

2009-10-07 Thread Pan.Pantziarka
I have an XML configuration file which is shared across a number of applications. My install appends to the this file OK, but when I uninstall it deletes the config file rather than just removing the elements that were inserted by the install. A snippet of the install code: util:XmlConfig

[WiX-users] Shortcuts for peruser/permachine

2009-10-07 Thread Nick Ball
Hi All, I've read the How To in the WiX documentation on this, but I am confused. My application is typically installed by administrator, yet students need to be able to log on and use it, so it makes sense to make the installer perMachine. The example of how to create a shortcut, however,

Re: [WiX-users] Uninstall deleting config file

2009-10-07 Thread Pally Sandher
http://wix.sourceforge.net/manual-wix3/wix_xsd_component.htm Put SettingsXmlFile in it's own Component set 'Permanent=yes' on that Component. It'll never be removed then. I sincerely doubt XMLConfig is deleting your XML file during uninstall. If you put a file on the machine during install,

Re: [WiX-users] Unable to use Xpath expressions

2009-10-07 Thread Blair
I would have to refresh my memory on the entire history, but IIRC it was something like this: XmlFile was developed first, and simply wraps the msxml3 interface as much as is practical in an environment such as this one. It was possibly done without knowing the full history of the msxml evolution

Re: [WiX-users] Uninstall deleting config file

2009-10-07 Thread Blair
Alternately, if you want the file removed when all sharing programs have been removed, make sure that the config file is the keypath of the component that installs it AND that the same component GUID is used in each of the products. Then the file will be kept for until the last remaining program

Re: [WiX-users] Shortcuts for peruser/permachine

2009-10-07 Thread Blair
The ICE wants shortcuts in components with HKCU registry keypaths because it is possible to remove the ALLUSERS value from your installation from the commandline even if it is present in the Property table (making your installation per-user instead of per-machine, even if that breaks other things

Re: [WiX-users] Patch for specific files?

2009-10-07 Thread Blair
Sure. That is what PatchFamilies are all about. -Original Message- From: Sunkesula, Srivardhan [mailto:srivardhan.sunkes...@netapp.com] Sent: Wednesday, October 07, 2009 12:59 AM To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] Patch for specific files? Can

Re: [WiX-users] Problem with decompilation using dark.exe

2009-10-07 Thread Blair
Contribute code to WixIISExtension? I opine that this would qualify for a bug request. -Original Message- From: Bojan Ivanovic [mailto:bojan.ivano...@aricent.com] Sent: Wednesday, October 07, 2009 1:29 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Problem with

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Dominique Louis
Thanks for sharing this with us. I think it may just be what I'm looking for. Which stored procs are not in SQL2008? From what I can tell they are still there, but have been marked for deprecation in future versions of SQLServer. Dominique. -Original Message- From: Michael Osmond

[WiX-users] Prevent install from failing if XmlFile element doesn't exist

2009-10-07 Thread Evan Beeton
Hello, I'm very new to WiX and Windows Installers in general. I'm writing an installer that's a new add-on for an existing product. The existing product has an XML file that I need to update. The new installer uses XmlFile setValue to rename a specific attribute in that XML file upon installation.

[WiX-users] Create shortcut for file in merge module

2009-10-07 Thread Dave Mateer
Sorry, noob question, but I can't figure it out. How do you create a shortcut to a file in a merge module? I have a common set of components that need installed in two contexts: one, as a standalone, and the other, as part of a larger application. I am putting the common components in a merge

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Michael Osmond
Dominique I think your right that the SPs are still in 2008, I tested this yesterday on 2008, it looks okay. Michael From: Dominique Louis [dominique.lo...@amxeurope.com] Sent: Thursday, 8 October 2009 4:10 AM To: General discussion for Windows

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Farooq Mahmud (Hotmail)
Dominique, You should really use the following in SQL Server 2008 to avoid additional rework once these are deprecated: Instead of sp_addlogin use CREATE LOGIN... Instead of sp_grantdbaccess use CREATE USER... To check if the server login exists, run the following: SELECT 1 FROM

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Michael Osmond
Farooq Thanks for that Michael From: Farooq Mahmud (Hotmail) [farooq...@hotmail.com] Sent: Thursday, 8 October 2009 7:44 AM To: 'General discussion for Windows Installer XML toolset.' Subject: Re: [WiX-users] Creating SQLServer Users/Logins

Re: [WiX-users] Test sql connection

2009-10-07 Thread Farooq Mahmud (Hotmail)
There are a couple of ways to do this: 1. Write a custom action that connects to the database and runs a basic SELECT query. Schedule the CA before LaunchConditions or when the Test button is clicked. 2. Use SqlDatabase and SqlString elements to connect to the database and run a basic SELECT

Re: [WiX-users] Permission element question

2009-10-07 Thread Farooq Mahmud (Hotmail)
It looks like all the Permission flavors don't honor the inheritance setting. I ended up writing custom actions that appended the required permissions to the existing set of permissions on the file system and registry objects. -f -Original Message- From: Blair [mailto:os...@live.com]

[WiX-users] Condition-element

2009-10-07 Thread Ali Khan
Hi - In order to add Conditions to allow installing my application only on certain Operating Systems I am using WiX’s Condition-Element. When I add the first four conditions, the installer builds successfully: !-- Vista SP2 or above -- !-- XP SP3 or above -- !-- Windows Server 2003 SP2 or

Re: [WiX-users] Condition-element

2009-10-07 Thread Blair
You will want to test this, but: !-- Verify not an Unknown OS -- Condition Message=$(var.ProdName) is not supported on this version of Operating System. ![CDATA[VersionNT=501 OR VersionNT=502 OR VersionNT=600 OR VersionNT=601]] /Condition !-- Verify Vista SP2 or above --

[WiX-users] Conditional Custom Actions

2009-10-07 Thread brett king
I have a custom action that takes user information and writes a configuration file.  My two questions are: 1. How can I put a condition on the custom action to only write if when a specific feature is selected for installation? 2. Do I have to create another custom action to remove this

Re: [WiX-users] Conditional Custom Actions

2009-10-07 Thread Farooq Mahmud (Hotmail)
Brett, For #2, if the file is being installed by a Component then the file will be removed on uninstall like any other file. For #1, use the feature-condition syntax shown at http://msdn.microsoft.com/en-us/library/aa368012(VS.85).aspx. Note that for this to work the CA must be scheduled after

[WiX-users] Unable to create app shortcut on desktop

2009-10-07 Thread Sudripta Nandy
In my setup, I need to create a shortcut to my application executable on the desktop. I am doing the following: Component Id='SSComponentMyApp' Guid='B52F5FD8-6699-4816-BCAB-D9D7B4C88A42' File Id='SSFileMyApp' Name=MyApp.exe' DiskId='1' Source ='MyApp.exe' Shortcut Id=SSLinkMyApp