Re: [WiX-users] Attach a database

2008-06-14 Thread Tim Fisher
Yes, you're right it does. Ok, your suggestions worked. Now my SQL scripts run correctly. Thank you! One thing to note is that if I tried to use ExecuteOnInstall in the same element with a RollbackOnUninstall, then it doesn't get executed at all (undocumented). Anyway I have a new problem, during

Re: [WiX-users] Attach a database

2008-06-13 Thread Tim Fisher
h the confusion and frustration of trying to learn wix. Tim On Thu, Jun 12, 2008 at 6:18 PM, Tim Fisher <[EMAIL PROTECTED]> wrote: > I created a new wxs file with a Fragment in it, then I moved my SqlDatabase > element over into the Fragment element like this: > > http://schemas.mi

Re: [WiX-users] Attach a database

2008-06-12 Thread Tim Fisher
I created a new wxs file with a Fragment in it, then I moved my SqlDatabase element over into the Fragment element like this: http://schemas.microsoft.com/wix/2006/wi"; xmlns:sql="http://schemas.microsoft.com/wix/SqlExtension";>

Re: [WiX-users] Setting properties

2008-06-12 Thread Tim Fisher
Oops, nevermind. The condition goes inside the Custom element in the install sequence, not in the CustomAction element. Tim On Thu, Jun 12, 2008 at 11:50 AM, Tim Fisher <[EMAIL PROTECTED]> wrote: > If I try to compile that, it tells me the CustomAction element > contains illega

Re: [WiX-users] Setting properties

2008-06-12 Thread Tim Fisher
If I try to compile that, it tells me the CustomAction element contains illegal inner text. :( Tim On Thu, Jun 12, 2008 at 11:08 AM, Brian Simoneau <[EMAIL PROTECTED]> wrote: > > Use a custom action to set ANOTHER_PROP to PROP1 with a condition that > PROP1 exists. Something like > Value="[PROP

Re: [WiX-users] Attach a database

2008-06-06 Thread Tim Fisher
hould I be using something else to do this? Tim On Thu, Jun 5, 2008 at 8:45 PM, Rob Mensching <[EMAIL PROTECTED]> wrote: > At the top of the Fragment: > > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Fisher

Re: [WiX-users] Attach a database

2008-06-05 Thread Tim Fisher
FROM > sys.server_principals WHERE name = N'$(var.ServiceAccount)') EXEC > master.dbo.sp_grantlogin '$(var.ServiceAccount)'; USE $(var.LongDBName); IF > EXISTS(SELECT name FROM sys.sysusers WHERE name=N'$(var.ServiceAccount)') >

Re: [WiX-users] Attach a database

2008-06-05 Thread Tim Fisher
Ok here's what I have now. It installs correctly, but the uninstall fails with 0x80004005 failed to connect to database. Tim - Check out the new SourceF

[WiX-users] Attach a database

2008-06-05 Thread Tim Fisher
I'm using WiX 3.0.4130.0 and I'm trying to figure out how to attach a database. I'm getting a runtime error using this method: The log file looks good, but the error looks like it's tryi

[WiX-users] Find MSSQL Data directory?

2008-06-04 Thread Tim Fisher
Is there a way to find the MSSQL Data directory, where the database files should be placed? Tim - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source.

Re: [WiX-users] Building a connection string RegistryValue

2008-06-03 Thread Tim Fisher
ity=SSPI" while the CustomAction assigns to NotIntegratedSecurity the value "{User Id=[USERIDVALUE];Password=[PWDVALUE];}" and everything works! Tim On Tue, Jun 3, 2008 at 4:16 PM, Tim Fisher <[EMAIL PROTECTED]> wrote: > OK, so I need a CustomAction that assigns to CONNE

Re: [WiX-users] Building a connection string RegistryValue

2008-06-03 Thread Tim Fisher
n do one of two different assignments based on a condition? Tim On Tue, Jun 3, 2008 at 12:44 PM, Bob Arnson <[EMAIL PROTECTED]> wrote: > Tim Fisher wrote: >> > Type="string" >>

[WiX-users] Building a connection string RegistryValue

2008-06-03 Thread Tim Fisher
I recently downloaded WiX 3.0.4130.0 and figured out how to make it work from the docs and various Internet sources. A steep learning curve, to say the least. I figured out how to make a custom dialog box, with text boxes for the user to fill in and I inserted it into the UI sequence. Here's my pro