I have a requirement to use special characters in an Informix ODBC connection string from within a Powershell script. The password should match the users Windows password. Several ODBC related posts suggest using braces {...} to protect the password, but this does not work.
I'm using Informix ODBC driver 3.34 32BIT
The following connection string with a simple password works:
$conn.connectionstring = "DSN=PD7333;Uid=generic;Pwd=readonly;"
This does not work. "DSN=PD7333;Uid=generic;Pwd={readonly};"
Any suggestions to protect special characters in an Informix ODBC connection string?