Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-18 Thread sai rahul
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 Ope

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-18 Thread Rob Mensching
, 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

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-17 Thread sai rahul
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 Mob

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-16 Thread sai rahul
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

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-16 Thread sai rahul
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. Ra

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-16 Thread Christopher Karper
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 1

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-16 Thread sai rahul
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 h

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-16 Thread sai rahul
ok.. when i checked in the log... its showing the SqlString as Property(S): RollbackExecuteSqlStrings = masterDb€NEWTON\SQLEXPRESS€€MasterDb€3€1€€€ExecuteProc€11€exec sp_InstallDefaults and the SqlScript to create the Procedure is showing as Property(S): ExecuteSqlStrings = finmap€NEWTON\SQLEXP

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-15 Thread Christopher Karper
half 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 e

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-15 Thread Chad Petersen
f 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

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-15 Thread sai rahul
l 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

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-15 Thread Chad Petersen
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

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-15 Thread sai rahul
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 Ka

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-15 Thread sai rahul
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

Re: [WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-15 Thread Christopher Karper
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 Sto

[WiX-users] Executing Sql Stored Procedure from SqlString

2008-07-15 Thread sai rahul
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. Th