Loading
How to pass correctly quoted value as property value?

I have to pass connection string as a part of property value like that:

MsiHiddenProperties="[MsiHiddenProperties]" Parameters="[SUPPORTDIR];[CONNECTION_STRING];[Param1];[Param2]"

[CONNECTION_STRING] is also a parameter. Its value is 'Server=(local);Database=UserDb;User ID=userId;Password= "Password" ;Encrypt=True;TrustServerCertificate=True;max pool size=1000'.

I want to have Password wrapped with double quotes - "Password" - cause it can contains double quotes inside the password value and I want to use it later in PS script.

If I pass CONNECTION_STRING as mentioned earler my Parameters wiil be cut while parser finds first occurence of double quotes in CONNECTION_STRING.

I tried following: 'Server=(local);Database=UserDb;User ID=userId;Password= ""Password"" ;Encrypt=True;TrustServerCertificate=True;max pool size=1000'. (https://learn.microsoft.com/en-us/windows/win32/msi/command-line-options)

'Server=(local);Database=UserDb;User ID=userId;Password= \"Password\" ;Encrypt=True;TrustServerCertificate=True;max pool size=1000'. (https://docs.revenera.com/installshield22helplib/Subsystems/installshield22langref/helplibrary/LangrefEscape_sequences.htm)

But failed, result was the same - property was cut.

What is the proper way to pass property with double quotes?

 


Loading
How to pass correctly quoted value as property value?