
VincentAngryDog asked a question.
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?