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

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

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 =

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

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

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.

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

[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.

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 Stored

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 and am

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 Karper

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

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

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

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

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

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

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

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