What I meant is that the SQL Server is installed on a different machine. When using WIX's SqlDatabase element I can specify a remote SQL Server (i.e. current machine is just a client, while SQL is installed on a remote Data Server). The machine where the MSI is installed does not have the SQL client installed, therefore I cannot use sqlcmd.exe.
On Thu, Nov 20, 2008 at 10:18 AM, Neil Sleightholm <[EMAIL PROTECTED]>wrote: > This is probably not relevant but if you don't have access to SQL how do > you expect any solution to work? > > Neil > > Neil Sleightholm > X2 Systems Limited > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > ________________________________ > > From: Eitan Behar [mailto:[EMAIL PROTECTED] > Sent: Wed 19/11/2008 19:11 > To: 'General discussion for Windows Installer XML toolset.' > Subject: Re: [WiX-users] Modifying the MSI file at runtime using DTF > > > > Hi Neil, > > Thanks, I already went to it, and even recommended to a few people. But, I > cannot use it on my scenario since the MSI are deployed on servers without > SQL installed. SQL is running in a different server where I don't have > access. > > Thanks, > > Eitan > > - beginning to be frustrated.... > > > > -----Original Message----- > From: Neil Sleightholm [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 19, 2008 9:01 PM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Modifying the MSI file at runtime using DTF > > There is an alternative approach here > http://neilsleightholm.blogspot.com/2008/08/executing-sqlcmd-from-wix.html > that might be useful. > > Neil > > Neil Sleightholm > X2 Systems Limited > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > ________________________________ > > From: Eitan Behar [mailto:[EMAIL PROTECTED] > Sent: Wed 19/11/2008 18:53 > To: 'General discussion for Windows Installer XML toolset.' > Subject: Re: [WiX-users] Modifying the MSI file at runtime using DTF > > > > I am trying to do the almost famous replaces on SQL Scripts before running > them. I only have a few days to do that, and cannot get into writing a > generic C++ as an add-on to the existing SQL Extensions. > > There are a bunch of SQL scripts, which I cannot modify, and they have a > lot > of replaceable %Parameters% > > I know it's ugly, but copy+pasting several 6K row scripts into SQLString > elements is not an option. > > I will really appreciate, even more than usual, if there is a nice > workaround at hand. > > Thanks, > > Eitan > > > > -----Original Message----- > From: Rob Mensching [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 19, 2008 8:17 PM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Modifying the MSI file at runtime using DTF > > You can't do that. The MSI is readonly. > > What are you trying to accomplish? > > -----Original Message----- > From: Eitan Behar [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 19, 2008 09:47 > To: General discussion for Windows Installer XML toolset. > Subject: [WiX-users] Modifying the MSI file at runtime using DTF > > Hi, > > I am trying to modify the MSI file at runtime, basically, I am running a > DTF > Custom Action (immediate, after InstallInitialize) that extract certain > Binary files, modify them, and save them back into the MSI file. > > The problem is that I cannot save the files back to the binary table. I am > using the sample provided with the DTF documentation: > > db = new Database(session["DATABASE"], DatabaseOpenMode.Direct); ... > > session["DATABASE"] gives me the actual msi file (from the > Windows\Installer > folder). > > But, I am getting an ugly error: > Microsoft.Deployment.WindowsInstaller.InstallerException: The system cannot > open the device or file specified. > Database="C:\WINDOWS\Installer\e659b.msi" > > Looks like the database is locked. > > Please, I would like to know if what I want to do is doable, and if yes, > what is the correct approach? > > Thanks in advance, > > Eitan > ------------------------------------------------------------------------- > 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 > > > > > ------------------------------------------------------------------------- > 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
