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,

Re: [WiX-users] Attach a database

2008-06-13 Thread Tim Fisher
with 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: Wix xmlns=http://schemas.microsoft.com/wix/2006

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 CustomAction

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 illegal inner text. :( Tim

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: Wix xmlns=http://schemas.microsoft.com/wix/2006/wi; xmlns:sql=http://schemas.microsoft.com/wix/SqlExtension; Fragment sql:SqlDatabase Id=DB1

Re: [WiX-users] Attach a database

2008-06-06 Thread Tim Fisher
Of Tim Fisher Sent: Thursday, June 05, 2008 16:53 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Attach a database Can you show the definition for your LocalMasterDB element? Tim On Thu, Jun 5, 2008 at 1:35 PM, Rob Mensching [EMAIL PROTECTED] wrote: I

[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: Component Id=Component2 Guid=c57c91e1-d185-49c1-91f9-fc41a26298a3 File Id=MDF Name=MyDb.mdf Source=MyDb.mdf KeyPath=yes / File

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. Component Id=Component2 Guid=c57c91e1-d185-49c1-91f9-fc41a26298a3 File Id=MDF Name=MyDb.mdf Source=MyDb.mdf KeyPath=yes / File Id=LDF Name=MyDb_log.ldf

Re: [WiX-users] Attach a database

2008-06-05 Thread Tim Fisher
$(var.LongDBName).dbo.sp_droprolemember 'db_owner', '$(var.ServiceAccount)' / -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Fisher Sent: Thursday, June 05, 2008 08:58 To: wix-users@lists.sourceforge.net Subject: [WiX-users] Attach a database I'm

[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

[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

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

2008-06-03 Thread Tim Fisher
assignments based on a condition? Tim On Tue, Jun 3, 2008 at 12:44 PM, Bob Arnson [EMAIL PROTECTED] wrote: Tim Fisher wrote: RegistryValue Name=ConnectionString Type=string Value={Data Source=[DBSERVERNAME];[[USEINTEGRATEDSECURITY]]} / ... Property Id

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

2008-06-03 Thread Tim Fisher
the CustomAction assigns to NotIntegratedSecurity the value {User Id=[USERIDVALUE];Password=[PWDVALUE];} and everything works! Whew Tim On Tue, Jun 3, 2008 at 4:16 PM, Tim Fisher [EMAIL PROTECTED] wrote: OK, so I need a CustomAction that assigns to CONNECTIONSTRING property from a number of different