Get and Use connectionstring for XML file

[Myhlendorph]

Hi
Hope someone can tell me how to get the connectionstring used by installshield for creating database throught sql script.
Thanks

Ekstra: I have to use this connectionstring for updating af node in a settings.xml file. Is this is impossible please stop me 🙂

Thanks in advance

Best regards
Bo

[Myhlendorph]

Is it possible creating or getting a connectionString from InstallShield like this:

connectionString="Data Source=LocalPc\SQLEXPRESS;Initial Catalog=;Integrated Security=True"

Thanks,-

[skolte]

Yes, it is possible. There are multiple ways to do it. You can use XML edit feature in InstallShield or InstallScript or a custom action.

Here's a sample that demonstrates editing an XML file using InstallScript. The file updates license number as discussed in this thread but same concept can be used to update any other XML node.