I have an installscript where I am populating values of IS_SQLSERVER_SERVER, IS_SQLSERVER_DATABASE from the SQL dialog SQLServerSelectLogin2. When I read the properties right afterwards, they reflect the values I entered in the SQL dialog. However, when I try to read them at a different stage, like MoveData\OnInstallFilesActionAfter, or AfterMoveData\OnFirstUIAfter, the properties are blank. What do I need to do to retain them throughout the installation? Thanks! ... View more

Just wondering if there is a built in function to connect to a database using a pre-existing UDL file in installscript. Is it possible to do this, or do we need to parse the UDL file? Thanks! ... View more

I am using the System Search utility to pull a value from a XML file and I'd like to use that value as the basis for another System Search in the same file. Is it possible to do this? I've tried using the [PROPERTY] but it just comes up blank. So, first system search XPath config: /DATASuite/Connection/DefaultPlant Value of Attribute: Name Property: DEFAULTPLANTNAME In the second search, /DATASuite/Connection/Site/Site[@Name=[DEFAULTPLANTNAME]] Value of Attribute: Connection Property: DEFAULTCONNECTIONSTRING Any ideas on how to make this work? ... View more

[reposted from earlier post - forgot to change subject] thanks to the help in this board, I was able to customize the SQLServerSelectLogin2 dialog and add a browse button where the user can choose a directory path for the database location. Now, I have just realized that there is not a way to specify the database location in the SQL Scripts views of Installshield. can anyone point me to how I can customize the location of the database when Installshield creates it (i.e. the "Create Catalog if Absent" checkbox is checked.) Thanks! ... View more

thanks to the help in this board, I was able to customize the SQLServerSelectLogin2 dialog and add a browse button where the user can choose a directory path for the database location. Now, I have just realized that there is not a way to specify the database location in the SQL Scripts views of Installshield. can anyone point me to how I can customize the location of the database when Installshield creates it (i.e. the "Create Catalog if Absent" checkbox is checked.) Thanks! ... View more

Is it possible to specify the NetworkService account when configuring a service via the Organization\Components view in installshield? I can get it to install as LocalSystem if we leave it blank, but we need NetworkService instead. I have tried ".\NetworkService" but it fails during the install with a permissions error. Thanks! ... View more

can't seem to find the code for this dialog. How would I go about customizing this? Specifically, I want to add an additional field towards the bottom of the dialog so the user can enter the address of a SQLReporting Services server, rather than create a new dialog to do that. I modified the template, but I need to get into the code to use the new field. Thanks! ... View more

I have a sql script that creates a database. I imported it into SQL Scripts. SQL I have the script written like this: /* Deployment script for Con.ContentServer.DB */ GO SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, NUMERIC_ROUNDABORT, QUOTED_IDENTIFIER OFF; GO :setvar DatabaseName "Con.ContentServer.DB" :setvar DefaultDataPath "C:\Program Files\Microsoft SQL Server\MSSQL10.CON\MSSQL\DATA" :setvar DefaultLogPath "C:\Program Files\Microsoft SQL Server\MSSQL10.CON\MSSQL\DATA" GO USE [master] GO :on error exit When I run the installer, it fails: Error 27506. Error executing SQL Script con.contentserver.db.sql. Line 15. Incorrect syntax near ':'. (102) I am not sure exactly where it is failing - Line 15 takes me to the GO directive after the :setvars. if I ignore the comments, it takes me to the GO directive just before the ':on error exit'. Am I better off running this another way? Any help would be appreciated! ... View more