SYMPTOM:
A user launches a command with the following syntax in Linux, in order to create a new DSN:
Sample Code/Error
mstrconnectwiz -u: -p:
Note that the password contains the dollar character '$'. The following error is returned:
Sample Code/Error
./mstrconnectwiz SQLSERVER test1 ,1433 -u: -p:$tr4tegy
tr4tegy: Undefined variable.
If the same command is executed without the user name and password parameters, the DSN is successfully created (the information is written to the odbc.ini without testing the connection). The same is true if only the $ character is removed from the password.
In Developer it is possible to configure passwords containing the $ character for existing DSNs.
CAUSE:
The dollar symbol '$' is interpreted by bash (or any other Linux shell) as the flag character for variables. Any string placed immediately after a $ will be treated as a variable, and the execution of the command will fail if that variable is not recognized.
ACTION:
Strategy Technical Support suggests avoiding the usage of reserved characters in all syntaxes that may be misinterpreted as a shell command.
