Re: [WiX-users] [WIX-Users] Not allowed to installer a folder with spaces in it?

2008-12-01 Thread Peter McClymont
Thanks you guys are right on the Money.

Thanks for your help.

On Tue, Dec 2, 2008 at 7:30 PM, Eitan Behar <[EMAIL PROTECTED]> wrote:

> Hi Peter,
>
> Directory refers to a Directory Id, therefore it cannot contains spaces.
>
> What you want to accomplish is:
>
> 
>  
>  Guid="FF63AA3E-C02D-11DD-AD5B-1C9356D89593">
>
>
>   
> 
>   
>  
>
>
>
>
> On Tue, Dec 2, 2008 at 8:11 AM, Peter McClymont
> <[EMAIL PROTECTED]>wrote:
>
> > Hi All,
> >
> > I have this code snippet in my WIX script,
> >
> > 
> >   > Guid="FF63AA3E-C02D-11DD-AD5B-1C9356D89593">
> >
> >
> > On="uninstall"/>
> >  
> >
> >
> > Which should create a directory called
> >
> > Documents\My iCalibra Flow Plans
> >
> > Instead when I compile it I get an error,
> >
> > The CreateFolder/@Directory attribute's value, 'My iCalibra Flow Plans',
> is
> > not a legal identifier.  Identifiers may contain ASCII characters A-Z,
> a-z,
> > digits, underscores (_), or periods (.).  Every identifier must begin
> with
> > either a letter or an underscore.
> > C:\Dev\iC3\Source\iC3InstallerWIX\Product.wxs
> >
> > Is there any way around this?
> >
> > Thanks,
> >
> > Peter.
> > -
> > This SF.Net email is sponsored by the Moblin Your Move Developer's
> > challenge
> > Build the coolest Linux based applications with Moblin SDK & win great
> > prizes
> > Grand prize is a trip for two to an Open Source event anywhere in the
> world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > ___
> > WiX-users mailing list
> > WiX-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/wix-users
> >
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ___
> WiX-users mailing list
> WiX-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wix-users
>
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users


[WiX-users] [WIX-Users] Not allowed to installer a folder with spaces in it?

2008-12-01 Thread Peter McClymont
Hi All,

I have this code snippet in my WIX script,


  



  


Which should create a directory called

Documents\My iCalibra Flow Plans

Instead when I compile it I get an error,

The CreateFolder/@Directory attribute's value, 'My iCalibra Flow Plans', is
not a legal identifier.  Identifiers may contain ASCII characters A-Z, a-z,
digits, underscores (_), or periods (.).  Every identifier must begin with
either a letter or an underscore.
C:\Dev\iC3\Source\iC3InstallerWIX\Product.wxs

Is there any way around this?

Thanks,

Peter.
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users


[WiX-users] My documents folder from within WIX

2008-12-01 Thread Peter McClymont
Hi All,

I have a WIX installer that uses the 'LocalAppDataFolder' property to get
the data folder directory (it is different for different OSs).

I want to do the same for the 'My documents' folder. What is the
corresponding property?

Thanks,

Peter.
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users


[WiX-users] [WIX-Users]

2008-12-01 Thread Peter McClymont
Hi All,

I have a WIX installer that uses the 'LocalAppDataFolder' property to get
the data folder directory (it is different for different OSs).

I want to do the same for the 'My documents' folder. What is the
corresponding property?

Thanks,

Peter.
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users


Re: [WiX-users] How to run another msi from our msi installer

2008-12-01 Thread Peter McClymont
Running an msi from another msi is not supported, and will not work.

What you have to do is create a bootstrapper. This is an exe file that will
check for certain prerequisites and install them, and then it will run your
msi.

I have found the 'bootstrap manifest generator' to be of use (it is a bit
unstable though). Have a look here,

http://code.msdn.microsoft.com/bmg

Also you can use visual studio to create a bootstrapper for you. When you
create an installer package within visual studio it gives you bootstrapper
options, and then spits out a file called setup.exe

Search around on google, there is heaps out there on the subject. Otherwise
get back to me if you want more of a hand.

On Tue, Dec 2, 2008 at 4:45 PM, zhwee ant <[EMAIL PROTECTED]> wrote:

> Hello ,  how  can i  run another msi (like xml parse installer  , or dot
> net framework)  from my installer?
>
>
>
>  ___
> Dapatkan nama yang Anda sukai!
> Sekarang Anda dapat memiliki email di @ymail.com dan @rocketmail.com.
> http://mail.promotions.yahoo.com/newdomains/id/
> -
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> ___
> WiX-users mailing list
> WiX-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wix-users
>
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users


Re: [WiX-users] Running SQL scripts under WIX

2008-11-27 Thread Peter McClymont
Thanks guys. That is right on the money to do with ANSI and UNICODE. I found
this too FYI,

http://n2.nabble.com/Error-executing-sql-scripts-with-WIX-td1488703.html

And the characters in that post were the same ones I had.

But I remember now, the first time I created that script I used visual
studio to create a text file for me. This time around I created a blank file
using notepad and used that.

Thanks,

Peter.

On Fri, Nov 28, 2008 at 2:22 PM, Joe Osman <[EMAIL PROTECTED]> wrote:

> Hi Peter,
> What happen if you use sqlcmd to run the script? Do you get the same error
> ?
> Joe
>
> Michael Osmond wrote:
> > Peter,
> >
> > I am not sure of all the details, but try saving the SQL script as ANSI
> > format.
> >
> > Michael
> >
> > -Original Message-
> > From: Peter McClymont [mailto:[EMAIL PROTECTED]
> > Sent: Friday, 28 November 2008 11:01 AM
> > To: wix-users@lists.sourceforge.net
> > Subject: [WiX-users] Running SQL scripts under WIX
> >
> > Hi All,
> >
> > I have a rather disturbing problem that I am having a lot of trouble
> > figuring out.
> >
> > Our WIX installer is adding a database, and running a SQL script as it
> > does the install. It looks like this,
> >
> >  > SourceFile="$(var.iC3.TargetDir)\SQLScripts\CreateTables.sql" />
> >
> > 
> >   
> > 
> >   
> >  > Guid="dd6f7b80-bcbb-11dd-ad8b-0800200c9a66">
> >> CreateOnInstall="yes" Instance="SQLExpress" Server="localhost"
> > DropOnUninstall="yes" ContinueOnError="yes">
> >  > BinaryKey="CreateTableScript" ContinueOnError="no"
> > ExecuteOnInstall="yes"/>
> >   
> > 
> > 
> >   
> > 
> >   
> >
> > And the SQL script looks like this (the first part anyway),
> >
> > SET ANSI_NULLS ON
> > GO
> >
> > SET QUOTED_IDENTIFIER ON
> > GO
> >
> > CREATE TABLE [dbo].[CollectedBatchStore](
> > [uid] [int] IDENTITY(1,1) NOT NULL,
> > [CollectedBatchStoreName] [nvarchar](50) NOT NULL,
> > [DataType] [smallint] NOT NULL,
> >  CONSTRAINT [PK_dbo.CollectedBatchStore] PRIMARY KEY CLUSTERED (
> >
> >
> > ETC ETC
> >
> > Anyway it all compiles properly, but when I run the installer it
> > complains with an error message,
> >
> > Error -2147217900: failed to execute SQL string. Incorrect syntax near
> > '>>'
> > (this is a funny character which has 2 arrows in one character)
> >
> > I look at the SQL profiler to see what SQL it is running, and I see
> > this,
> >
> > Drop database Database
> > Create database Database
> > exec i>>?SET ANSI_NULLS ON
> >
> > You see after the exec above there are a few funny characters, and it
> > should be starting at the 'SET ANSI_NULL ON' part of that statement. I
> > don't understand where the characters are coming from.
> >
> > Thanks,
> >
> > Peter.
> > 
> > -
> > This SF.Net email is sponsored by the Moblin Your Move Developer's
> > challenge Build the coolest Linux based applications with Moblin SDK &
> > win great prizes Grand prize is a trip for two to an Open Source event
> > anywhere in the world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > ___
> > WiX-users mailing list
> > WiX-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/wix-users
> >
> > -
> > This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> > Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> > Grand prize is a trip for two to an Open Source event anywhere in the
> world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > ___
> > WiX-users mailing list
> > WiX-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/wix-users
> >
> >
>
> ===
> This email, including any attachments, is only for the intended
> addressee.  It is subject to copyright, is confidential and m

[WiX-users] Running SQL scripts under WIX

2008-11-27 Thread Peter McClymont
Hi All,

I have a rather disturbing problem that I am having a lot of trouble
figuring out.

Our WIX installer is adding a database, and running a SQL script as it does
the install. It looks like this,




  

  

  

  


  

  

And the SQL script looks like this (the first part anyway),

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[CollectedBatchStore](
[uid] [int] IDENTITY(1,1) NOT NULL,
[CollectedBatchStoreName] [nvarchar](50) NOT NULL,
[DataType] [smallint] NOT NULL,
 CONSTRAINT [PK_dbo.CollectedBatchStore] PRIMARY KEY CLUSTERED
(


ETC ETC

Anyway it all compiles properly, but when I run the installer it complains
with an error message,

Error -2147217900: failed to execute SQL string. Incorrect syntax near '>>'
(this is a funny character which has 2 arrows in one character)

I look at the SQL profiler to see what SQL it is running, and I see this,

Drop database Database
Create database Database
exec i>>?SET ANSI_NULLS ON

You see after the exec above there are a few funny characters, and it should
be starting at the 'SET ANSI_NULL ON' part of that statement. I don't
understand where the characters are coming from.

Thanks,

Peter.
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users