Re: [WiX-users] Executing Sql Stored Procedure from SqlString
oh ok... thanks for the reply. - 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
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
SqlString only executes as a deferred custom action and does not set properties based on results of queries. So, no... but it is a totally reasonable feature request. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of sai rahul Sent: Thursday, July 17, 2008 00:34 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Executing Sql Stored Procedure from SqlString Sorry, i wasnt clear in the previous post. Can i use SqlString Select Query to get Currencies and Bind it to the ComboBox properties or do i have to write a custom action only? 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
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
Sorry, i wasnt clear in the previous post. Can i use SqlString Select Query to get Currencies and Bind it to the ComboBox properties or do i have to write a custom action only? 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
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
Hi I just have another doubt. I need to get Currencies from Database and bind those values to a combo box in a dialog after everything is installed in the database. How can i do this? 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
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
Yeah.. i've figured that out and i think ive found the source of the problem. I am actually adding Currency symbols. So, because of the Unicode values the Procedure is not getting executed. Ive typed the symbols from a hex editor and its working totally fine now. Thanks for the help guys. 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
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
Did you add the 'GO' statement? It's being passed as a parameter. Chris P.S. If you have profiler on another system, you can run it while the installer runs on the original system. It watches the SQL server, so as long as it can connect, it can profile for you. :-) Good luck! On Wed, Jul 16, 2008 at 4:41 AM, sai rahul <[EMAIL PROTECTED]> wrote: > Hello again, >I've removed the RollBackOnUninstall property for the SqlString and > changed the SQL property to "exec sp_InstallDefaults GO". Now its throwing > an error, the error statement is as follows: > > Error -2147217900: failed to execute SQL string, error detail: Procedure > sp_InstallDefaults has no parameters and arguments were supplied.. SQL key: > ExecuteProc SQL string: exec sp_InstallDefaults GO. > > My Stored Porcedure does not require any parameters or arguments, any idea > why its throwing the error??? > > 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
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
Hello again, I've removed the RollBackOnUninstall property for the SqlString and changed the SQL property to "exec sp_InstallDefaults GO". Now its throwing an error, the error statement is as follows: Error -2147217900: failed to execute SQL string, error detail: Procedure sp_InstallDefaults has no parameters and arguments were supplied.. SQL key: ExecuteProc SQL string: exec sp_InstallDefaults GO. My Stored Porcedure does not require any parameters or arguments, any idea why its throwing the error??? 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
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
ok.. when i checked in the log... its showing the SqlString as Property(S): RollbackExecuteSqlStrings = masterDbNEWTON\SQLEXPRESSMasterDb31ExecuteProc11exec sp_InstallDefaults and the SqlScript to create the Procedure is showing as Property(S): ExecuteSqlStrings = finmapNEWTON\SQLEXPRESSfinmap031UpdateScript1Create Procedure sp_InstallDefaults AS BEGIN .. can anyone figure out anything from this... i dont hav Profiler on my system.. so i will try on another system and update you guys. Thanks for the help. 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
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
Also, just include the text of the log around where your CA executes, to ensure that it is, in fact, executing as you expect. If the command is being issued, but the inserts are still failing, then you know the problem is more than likely downstream. Or it may be failing, but the install isn't configured to stop when that happens, in which case the log would clearly identify it. It won't solve your problem, but it should provide a clue on where to look next. Chris On Tue, Jul 15, 2008 at 12:34 PM, Chad Petersen <[EMAIL PROTECTED]> wrote: > Yeah, I haven't typically gotten much helpful from verbose logs for SQL > execution, but that might just be me. What has been helpful in some > cases is using SQL Profiler to see what it thinks is happening. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of sai rahul > Sent: Tuesday, July 15, 2008 8:43 AM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Executing Sql Stored Procedure from SqlString > > 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: > > > > > > > > > > > SourceFile="F:/Work/WixSetup/WixSetup/UpdateScript.sql" /> > > > > > > > > > > > ExecuteOnInstall="yes" Sequence="1" ContinueOnError="no" > > > SqlDb="masterDb"/> > > > > > > > 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 any
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
Yeah, I haven't typically gotten much helpful from verbose logs for SQL execution, but that might just be me. What has been helpful in some cases is using SQL Profiler to see what it thinks is happening. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of sai rahul Sent: Tuesday, July 15, 2008 8:43 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Executing Sql Stored Procedure from SqlString 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: > > > > > > > > SourceFile="F:/Work/WixSetup/WixSetup/UpdateScript.sql" /> > > > > > > > > ExecuteOnInstall="yes" Sequence="1" ContinueOnError="no" > > SqlDb="masterDb"/> > > > > > 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 > > > > - >
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
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: > > > > > > > > SourceFile="F:/Work/WixSetup/WixSetup/UpdateScript.sql" /> > > > > > > > > ExecuteOnInstall="yes" Sequence="1" ContinueOnError="no" > > SqlDb="masterDb"/> > > > > > 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.sou
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
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: > > > > > SourceFile="F:/Work/WixSetup/WixSetup/UpdateScript.sql" /> > > > > > ExecuteOnInstall="yes" Sequence="1" ContinueOnError="no" > SqlDb="masterDb"/> > > > 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
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
HI.. got the log file.. should i copy the whole thing here or mail it to you? On Tue, Jul 15, 2008 at 8:42 PM, sai rahul <[EMAIL PROTECTED]> wrote: > 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: >> > >> > > > SourceFile="F:/Work/WixSetup/WixSetup/UpdateScript.sql" /> >> > >> > > > ExecuteOnInstall="yes" Sequence="1" ContinueOnError="no" >> SqlDb="masterDb"/> >> >> > 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
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: > > > > > SourceFile="F:/Work/WixSetup/WixSetup/UpdateScript.sql" /> > > > > > ExecuteOnInstall="yes" Sequence="1" ContinueOnError="no" > SqlDb="masterDb"/> > > > 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
Re: [WiX-users] Executing Sql Stored Procedure from SqlString
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: > > SourceFile="F:/Work/WixSetup/WixSetup/UpdateScript.sql" /> > > ExecuteOnInstall="yes" Sequence="1" ContinueOnError="no" SqlDb="masterDb"/> > 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
[WiX-users] Executing Sql Stored Procedure from SqlString
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: 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
