Re: [WiX-users] Problem while creating objects by calling custom action

2009-10-08 Thread Farooq Mahmud (Hotmail)
quot;SERVERPROP"]; obj_PDBInformation.Server = session["PORTPROP"]; obj_PDBInformation.Server = session["USERPROP"]; So how to write a object's data like in above lines into custom table and iterate throught rows? Please give me example code to understand the concept.

Re: [WiX-users] Problem while creating objects by calling custom action

2009-10-08 Thread Farooq Mahmud (Hotmail)
It's not overwriting the old object, it is creating a new object each time the custom action is invoked so you can't save state like this. A better approach would be to write the object's data into a custom table. When you need to create the collection, iterate through the rows in the table, create

Re: [WiX-users] Unable to create app shortcut on desktop

2009-10-07 Thread Farooq Mahmud (Hotmail)
Try placing the Shortcut element under the Component instead of the File like the sample at http://wix.sourceforge.net/manual-wix3/create_start_menu_shortcut.htm. You would set the WorkingDirectory property to DesktopFolder. -farooq -Original Message- From: Sudripta Nandy [mailto:sudrip..

Re: [WiX-users] Conditional Custom Actions

2009-10-07 Thread Farooq Mahmud (Hotmail)
Brett, For #2, if the file is being installed by a Component then the file will be removed on uninstall like any other file. For #1, use the &feature-condition syntax shown at http://msdn.microsoft.com/en-us/library/aa368012(VS.85).aspx. Note that for this to work the CA must be scheduled after C

Re: [WiX-users] Permission element question

2009-10-07 Thread Farooq Mahmud (Hotmail)
s several known limitations), PermissionEx which works with Installer 5.0, and the WixUtilsExtension PermissionEx (doesn't use SDDL, but it is more flexible than Installer's built-in action). -Original Message----- From: Farooq Mahmud (Hotmail) [mailto:farooq...@hotmail.com] Sent: Tu

Re: [WiX-users] Test sql connection

2009-10-07 Thread Farooq Mahmud (Hotmail)
There are a couple of ways to do this: 1. Write a custom action that connects to the database and runs a basic SELECT query. Schedule the CA before LaunchConditions or when the Test button is clicked. 2. Use SqlDatabase and SqlString elements to connect to the database and run a basic SELECT quer

Re: [WiX-users] Creating SQLServer Users/Logins....

2009-10-07 Thread Farooq Mahmud (Hotmail)
Dominique, You should really use the following in SQL Server 2008 to avoid additional rework once these are deprecated: Instead of sp_addlogin use CREATE LOGIN... Instead of sp_grantdbaccess use CREATE USER... To check if the server login exists, run the following: SELECT 1 FROM sys.server_pri

[WiX-users] Permission element question

2009-10-06 Thread Farooq Mahmud (Hotmail)
I run an msi based on the code below. [ProgramFilesFolder] gives my built-in Users group read permission but my application folder does not inherit this permission. I use Windows Explorer to create a folder under [ProgramFilesFolder] and the folder does inherit the Users permission. Is there a