I'm using InstallShield 2009 and I cant for the life of me dynamically change the connection string in the web.config file - heres what I'm currently doing..
I have an SQL log-in dialog box where i enter in all of the SQL database log-in credentials, and in the "XML File Changes" section i'm loading my web.config values. Under connection string I'm making it equal to
Data Source=[IS_SQLSERVER_SERVER];Initial Catalog=[IS_SQLSERVER_DATABASE]; User ID=[IS_SQLSERVER_USER];pwd=[IS_SQLSERVER_PASSWORD]
When the installer runs, it changes the value but I end up with
<add name="MyConnectionString" connectionString="" providerName="System.Data.SqlClient"></add>
i.e. a BLANK connection string!
Can anyone tell me how to make the change so that it applies properly to the connectionString? All help appreciated...