Re: [WiX-users] SqlExtension -- SqlScript property substitution?

2014-06-02 Thread Tony
I'll answer my own question. No, SqlScript does not perform property substitution. I had thought property substitution rules were being followed when I was troubleshooting an install failure that had a msi log entry like this... ExecuteSqlStrings: Executing SQL string: CREATE TABLE .( IDENTI

[WiX-users] SqlExtension -- SqlScript property substitution?

2014-06-02 Thread Tony
Does the SqlExtension's SqlScript processing use installer property substitution rules? IOW, if my script contains... CREATE TABLE [MyDatabase].[MyTable]( [MyId] [int] IDENTITY(1,1) NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [nvarchar](256) NOT NULL ) Am I expected to escape all o

Re: [WiX-users] SqlExtension bug with existing databases

2010-03-14 Thread Rob Mensching
; wix-users@lists.sourceforge.net) > Subject: [WiX-users] SqlExtension bug with existing databases > > All, > > http://www.wixwiki.com/index.php?title=SqlExtension states: > > There is a serious bug with how the SqlExtension handles the SqlDatabase > Element when creating a

Re: [WiX-users] SqlExtension bug with existing databases

2010-03-13 Thread dB .
-answers.com] Sent: Thursday, March 11, 2010 3:46 PM To: General discussion for Windows Installer XML toolset. (wix-users@lists.sourceforge.net) Subject: [WiX-users] SqlExtension bug with existing databases All, http://www.wixwiki.com/index.php?title=SqlExtension states: There is a serious bug with how

[WiX-users] SqlExtension bug with existing databases

2010-03-11 Thread Bazarewsky, Michael C.
All, http://www.wixwiki.com/index.php?title=SqlExtension states: There is a serious bug with how the SqlExtension handles the SqlDatabase Element when creating a database. If a database with the same name already exists it will always be dropped. At this time it is not recommended to use the S

Re: [WiX-users] SQLExtension create database and access denied error

2009-08-31 Thread Michael Osmond
...@free.fr] Sent: Monday, 31 August 2009 7:31 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] SQLExtension create database and access denied error Hello, I'm trying to define a new SQL database using Wix, that has its files (MDF and LDF) in a specific folder (ideally in the u

[WiX-users] SQLExtension create database and access denied error

2009-08-31 Thread Crusty Applesniffer
Hello, I'm trying to define a new SQL database using Wix, that has its files (MDF and LDF) in a specific folder (ideally in the user's documents and settings, but this is another story) The thing is when I use the snippet :

Re: [WiX-users] SQLExtension, check if database exists

2008-12-11 Thread tgoffice
I have written a custom action, thanks for clarifaction Thomas -- View this message in context: http://n2.nabble.com/SQLExtension%2C-check-if-database-exists-tp1613865p1643613.html Sent from the wix-users mailing list archive at Nabble.com. -

Re: [WiX-users] SQLExtension, check if database exists

2008-12-04 Thread Rob Mensching
, 2008 07:12 To: wix-users@lists.sourceforge.net Subject: [WiX-users] SQLExtension, check if database exists Hello - once again :jumping: Is there a posibility to check if the installer had to create the database or if the database already existed? Our customers should have the posibility to use

[WiX-users] SQLExtension, check if database exists

2008-12-04 Thread tgoffice
Hello - once again :jumping: Is there a posibility to check if the installer had to create the database or if the database already existed? Our customers should have the posibility to use a new database (created by installer) or they should use an existing database. (I don't want to add a che

Re: [WiX-users] SQLExtension -- RESEND

2008-01-17 Thread Mike Dimmick
2008 18:31 To: wix-users@lists.sourceforge.net Subject: [WiX-users] SQLExtension -- RESEND Hi again, I still haven't gotten an answer to this, anyone? Hello, I believe there is a bug (from my perspective it's a bug anyway) in the way that the SQLExtension deploys SQL scripts (specifica

[WiX-users] SQLExtension -- RESEND

2008-01-17 Thread Quattro IV
Hi again, I still haven't gotten an answer to this, anyone? Hello, I believe there is a bug (from my perspective it's a bug anyway) in the way that the SQLExtension deploys SQL scripts (specifically stored procedures). The install functions correctly and even installs all of my scripts, stored pro

Re: [WiX-users] SQLExtension

2007-12-22 Thread Quattro IV
The page doesn't specify a bug number. See the end of this page http://www.wixwiki.com/index.php?title=SqlExtension in the section titled "Important Information" at the end. I already found that this has been fixed in the latest builds through testing. Thanks for responding. On Dec 21, 2007 3:50 A

Re: [WiX-users] SQLExtension

2007-12-21 Thread Rob Mensching
Do you have a bug number that explains this in more detail? I'm not sure what the wiki is referring to. Quattro IV wrote: > Hello, the wix wiki regarding the SQLExtension mentions "There is a > serious bug with how the *SqlExtension* handles the SqlDatabase > Element

[WiX-users] SQLExtension

2007-12-06 Thread Quattro IV
Hello, the wix wiki regarding the SQLExtension mentions "There is a serious bug with how the *SqlExtension* handles the SqlDatabase Elementwhen creating a database. If a database with the same name *already exists* it will always be *dropp

Re: [WiX-users] SqlExtension Rollback

2007-09-26 Thread Rob Mensching
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ben Greenberg Sent: Monday, September 17, 2007 12:03 To: wix-users@lists.sourceforge.net Subject: [WiX-users] SqlExtension Rollback After a SqlScript element is successfully executed, will it be rollbacked if the installer fails after

[WiX-users] SqlExtension Rollback

2007-09-17 Thread Ben Greenberg
After a SqlScript element is successfully executed, will it be rollbacked if the installer fails after that point? I see that a RollbackExecuteSqlStrings CA is created. If it does rollback, how is this accomplished at the SQL Server level? Thanks, Ben --