Hey, as i said before its not giving any error... just that the Stored procedure is not executing. So i guess the log file would be fine. I have it already.. but i guess its too big to paste in here...
Rahul On Tue, Jul 15, 2008 at 9:02 PM, Chad Petersen <[EMAIL PROTECTED]> wrote: > The syntax to create a verbose log file is > > MSIEXEC /L*v [logfilename] /i [yourinstall.msi] > > So something like > > MSIEXEC /L*v C:\MyLog.txt /i c:\test\myinstall.msi > > It logs in batches, so if you happen to get an error, say during a > custom action, and stop and open the log file it might not have logged > that particular problem yet. Typically you have to OK whatever the error > is and let it continue in order to then open the log file and see what > it is referring to. Just FYI there more than anything. > > Chad > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of sai rahul > Sent: Tuesday, July 15, 2008 8:12 AM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Executing Sql Stored Procedure from SqlString > > Nope.. sorry i dont know how to create one.. will try in the meanwhile > how > to create one... > > On Tue, Jul 15, 2008 at 8:19 PM, Christopher Karper < > [EMAIL PROTECTED]> wrote: > > > Do you have a log? > > > > On Tue, Jul 15, 2008 at 10:15 AM, sai rahul <[EMAIL PROTECTED]> > wrote: > > > > > Hi, > > > I am new to wix and am posting here for the first time. I've > creating a > > > database and running a script to add Tables to it, which is > happening > > > perfectly. Then i am running a script to create a Stored Procedure > which > > > inserts a few rows in some of the tables created, which is also > working > > > fine. Then i try to Execute the stored procedure using SqlString > element. > > > Though it is not showing any error and installation is happening > > > succesfully, the insert is not happening in any of the tables. I am > > > attaching the code for creating and executing the Stored Proc for > > > reference: > > > > > > <Binary Id="UpdateProcedure" > > > SourceFile="F:/Work/WixSetup/WixSetup/UpdateScript.sql" /> > > > > > > <Sql:SqlScript Id="UpdateDb" BinaryKey="UpdateProcedure" > > > ExecuteOnInstall="yes" Sequence="1" ContinueOnError="no" > > SqlDb="masterDb"/> > > > <Sql:SqlString Id="ExecuteProc" ExecuteOnInstall="yes" > > > ContinueOnError="no" RollbackOnUninstall="yes" Sequence="2" > > > SqlDb="masterDb" > > > SQL="exec sp_InstallDefaults"/> > > > > > > I am unable to figure out where i am going wrong. Any help wouldbe > really > > > appreciated. > > > > > > TIA > > > Rahul > > > > ------------------------------------------------------------------------ > - > > > 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
