[WiX-users] removal of comment in sql scripts by using SqlScript
Hello, At this moment scripts that are run during installation are stripped before processing. It is removing comment and spaces before it processes the script. (I checked in source code, this happens in scasqlstr.cpp line 282 and further for version 2.0.5805.0) Is there a good reason for this? I see what is the disadvantage: For instance: When I have a sql script like this: SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON GO -- This is important information CREATE PROCEDURE [dbo].[Test] AS BEGIN END GO Normal the comment in the script will be stored together with the database (you can try it with sp_helptext 'Test') With a wix-created installer this comment is gone. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] How to add sections properly to app.config
Hello, I am using Wix 2.0.5325.0 I have a app.config that I want to modify: Value MyValue I want to insert the blue lines. Remark, there are already lines before with the same node names before the inserted lines! I tried the following code in WIX: Now it works as expected until the red lines. I get the message fError 25542. Failed to find node: //configuration/applicationSettings/TestService.Properties.Settings/[EMAIL PROTECTED]" MyProperty"] in XML file: C:\Program Files\TestService\TestService.exe.config, system error: -2147020584 which is correct, while this node is not yet in the file. However when I leave out the red lines, the node is created. I also tried the lines below instead of the red lines: and several other things, but I was not able to create a xml-element with sub-elements in an existing XML file Anyone suggestions? Jaap - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Problem with VS2005
Hello, After not using WIX a while, we made a new release, and now VS2005 is crashing when i want to create a new WIX project. Also opening an old wix project, does not open anything. I already removed and reinstalled votive, but this did not solve the problem. I recently installed also Extensions for Windows WF, and .NET Framework 3.0Development tools as VS2005 plugins. Anyone else who also installed those plugins, but has no problems? Or (better) anyone who know about this problem and knows a workaround? Jaap - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Set Installdir
I do the same , I use After="LaunchConditions", which is about the first possible moment > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Alexander > Gnauck > Sent: donderdag 10 augustus 2006 10:39 > To: wix-users@lists.sourceforge.net > Subject: [WiX-users] Set Installdir > > > Hello, > > i have to set the Installdir directory depending on a registry value. Of > course the user can overwrite this default setting in the UI. > > So i read the path from the registry in a property and assign this > property to the installdir property with a custom action. My problem is > the sequencing of this custom action. What would be the correct sequence > for executing this custom action? > > Thanks Alex > > > - > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make > your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > ___ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] SqlScript and CustomActions
Actually until now I filled the database with sql string actions until now. It had to be an sql strings, because I was using some setup parameters, and the sql strings where > 1000 lines. And because I can do the same job with (existing) xml files and a custom action, this is far more elegant. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Michael > Osmond > Sent: donderdag 13 juli 2006 3:02 > To: Jaap de Wolff; wix-users@lists.sourceforge.net > Subject: Re: [WiX-users] SqlScript and CustomActions > > > Hello Jaap, > > I don't think you can sequence a custom action in between. The SQL > scripts are all executed by a single custom action themselves. > > Can you do your dataload through an slqstring or script instead of via > other custom actions? > > Michael > > > > -Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jaap de > Wolff > Sent: Thursday, 13 July 2006 12:33 AM > To: wix-users@lists.sourceforge.net > Subject: [WiX-users] SqlScript and CustomActions > > Hello, > > I want to create a database, run an sql script to create tables etc. > then do a few custom actions, which fill the database, and then execute > a few sql strings. > The last sql strings contain values which depend on customer choices. > My question is: > Is there a way of scheduling custom actions between some sql scripts, > and some sql strings? > > Jaap > > > > > > - > Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your job > easier Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > ___ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > - > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make > your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > ___ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] SqlScript and CustomActions
Hello, I want to create a database, run an sql script to create tables etc. then do a few custom actions, which fill the database, and then execute a few sql strings. The last sql strings contain values which depend on customer choices. My question is: Is there a way of scheduling custom actions between some sql scripts, and some sql strings? Jaap - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] help convincing management to use wix
Maybe a strong argument is telling them how commercially supported applications is working in the real world. As an example: A few years ago we discovered there was a bug in the MS COM component. This problem was a show stopper for us. We have a nice contract with MS that allows us to send them problem reports, and they will do what they can. But before they look at the problem report you have to reproduce it from scratch, on a machine containing only MS software, and your software. This means that you have to install operating system etc. before you even can send an error report. After you have sent an error report, they first look if it is a known problem (what mostly isn't, because we, developers, know how to google). Then after a few weeks they try to reproduce it. And then they confirm that there is a bug. (Look in there knowledge base how many confirmed, unresolved bugs there are). In our case, they even made a solution, a special patch we could do on the system (This was about two months after we reported the bug). And the best part: With SP2 the bug came back, and we had to report the same error once again. Now in Open Source land: When I report a bug, on a mailing list, within a few days there is always someone who can tell me in what module the problem is located, and, because I am a developer, I am able to look at it, if no one else does. We use in our company a lot of open source software, and with small problems, there was always a solution within a week. Jaap > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of steve baker > Sent: donderdag 1 juni 2006 21:12 > To: wix-users@lists.sourceforge.net > Subject: [WiX-users] help convincing management to use wix > > > hi all, > > i have been a long time wix user. my current employer uses wise to > build msi installations. i have used wise and installshield > extensively and have nothing good to say about either of them. > > part of my current job is to help rework our installer process. i have > proposed wix. our install builder has also researched wix at my > request and would like to switch. our managment does not want to use > wix because it is not a "commercially supported application". i have > talked about the mailing list and tremendous community support to no > avail. > > what i would like at this point is ideas from anyone out there to help > convince management to let us switch. names of large corporations that > are using wix, products inside of microsoft that have built thier > installations with wix, anything :) > > TIA :) > > > --- > All the advantages of Linux Managed Hosting--Without the Cost and Risk! > Fully trained technicians. The highest number of Red Hat certifications in > the hosting industry. Fanatical Support. Click to learn more > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642 > ___ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users