DSXchange

Oracle enterprise stage is failing to connect to the database if the password has a $ character in it.

I tried "$DS_ENABLE_RESERVED_CHAR_CONVERT = True" hoping that this column level setting would also work for the password. But that did not work.

I am setting the user id, password for the connection. I am getting the following error message
"Incorrect dboption list; it failed on Expected "," or "}", got: "$", line 1."

Will appreciate any help.

Thanks
Rati

You need to enclose your password within quotes. Before that you need to apply a patch. Refer herefor an ECASE number.

Thanks for your help. I will rather pick a fight with DBAs to change the password.

Whatever sails your boat