Re: [WiX-users] Attach a database

2008-08-15 Thread David Reed (SQL)
ge- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of silence8212 Sent: Friday, August 15, 2008 02:45 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Attach a database Hi David, thanks for your advise. Now I'm dropping database instead of detaching and it works accor

Re: [WiX-users] Attach a database

2008-08-15 Thread silence8212
you need to USE another database before you try to drop it). > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of silence8212 > Sent: Thursday, August 14, 2008 10:05 > To: wix-users@lists.sourceforge.net > Subject: Re: [WiX-

Re: [WiX-users] Attach a database

2008-08-14 Thread David Reed (SQL)
op, which won't work (you need to USE another database before you try to drop it). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of silence8212 Sent: Thursday, August 14, 2008 10:05 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Attach a d

Re: [WiX-users] Attach a database

2008-08-14 Thread silence8212
Hi Tim, thanks for a code example, I allowed to use this example in my scenario and it works perfect, but it doesn't delete database files and directory when uninstall. I want to delete database files after uninstall. This is code: ...

Re: [WiX-users] Attach a database

2008-06-14 Thread Rob Mensching
rally a good thing) to get the exact behavior you want. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Fisher Sent: Saturday, June 14, 2008 12:42 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Attach a database

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 Rob Mensching
ECTED] On Behalf Of Tim Fisher Sent: Friday, June 13, 2008 08:25 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Attach a database Turns out the sourceforge wix2 documentation regarding the SqlDatabase element is still valid for wix3's version of SqlDatabase. http://wix.sourc

Re: [WiX-users] Attach a database

2008-06-13 Thread Tim Fisher
id you get your > SqlStrings to work using a Fragment? > > Tim > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Rob Mensching > Sent: Friday, June 06, 2008 12:46 PM > To: General discussion for Windows Installer XML too

Re: [WiX-users] Attach a database

2008-06-12 Thread Tim Fisher
on for Windows Installer XML toolset. Subject: Re: [WiX-users] Attach a database If you place the SqlDatabase element under a Component element that will attempt to create the database. My SqlDatabase element is a direct child of one of my Fragment elements. It is a little confusing but that cause

Re: [WiX-users] Attach a database

2008-06-06 Thread Rob Mensching
naming a long time ago that hasn't been straightened out. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Fisher Sent: Friday, June 06, 2008 06:09 To: WiX-users Subject: Re: [WiX-users] Attach a database When I do it that way, I get a compile

Re: [WiX-users] Attach a database

2008-06-06 Thread 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 >

Re: [WiX-users] Attach a database

2008-06-05 Thread Rob Mensching
At the top of the Fragment: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf 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

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

Re: [WiX-users] Attach a database

2008-06-05 Thread Rob Mensching
): -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

[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