Use Credential Asset for SQL Query


#1

When i try to use the SqlCredential and passing the securesting password var to it, i requires a readonly securestring.

How do you convert securestring to read-only

When i try to do it in an assign via securestring.makereadonly() i get the error
"Expression does not produce a value"


#2

Hi,

.MakeReadOnly is a void method, so the error is correct.
You can use InvokeMethod activity to call void methods (Sub in VisualBasic).
Put your secure string variable as the Target Object and MakeReadOnly as Method name.

Regards.


#3

Thank you that solved it