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
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
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
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
[WiX-users] General, sai rahul has invited you to open a Google mail account
I've been using Gmail and thought you might like to try it out. Here's an invitation to create an account. ------- sai rahul has invited you to open a free Gmail account. To accept this invitation and register for your account, visit http://mail.google.com/mail/a-fc0a9e1d1a-0405165208-415510f3e7 Once you create your account, sai rahul will be notified with your new email address so you can stay in touch with Gmail! If you haven't already heard about Gmail, it's a new search-based webmail service that offers: - Over 2,700 megabytes (two gigabytes) of free storage - Built-in Google search that instantly finds any message you want - Automatic arrangement of messages and related replies into "conversations" - Powerful spam protection using innovative Google technology - No large, annoying ads--just small text ads and related pages that are relevant to the content of your messages To learn more about Gmail before registering, visit: http://mail.google.com/mail/help/benefits.html And, to see how easy it can be to switch to a new email service, check out our new switch guide: http://mail.google.com/mail/help/switch/ We're still working every day to improve Gmail, so we might ask for your comments and suggestions periodically. We hope you'll like Gmail. We do. And, it's only going to get better. Thanks, The Gmail Team (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser). - 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
[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