Page 1 of 1

Password

Posted: June 11th, 2024, 2:46 am
by YFT_CBSD
Hi,

I have issues in my batch application, i have hard coded the password:

setoutput(maketext("sample_data.csdbe|password=Gq26vm@5w%b&zF$E"));

when i open it via data viewer it says "The password is invalid"

but when i open it via data entry and set the password in the input data file it becomes:

sample_data.csdbe|password=Gq26vm%405w%25b&zF$E

i notice the symbol @ becomes %40, but when i try the "Gq26vm%405w%25b&zF$E" in the data viewer still "The password is invalid".

What to do?
Thanks.

Re: Password

Posted: June 11th, 2024, 10:13 am
by justinlakier
Hello,

Your password is using multiple special characters. This causes some problems as they are reserved for the connection string. If you want these special characters in your password, it needs to be Percent Encoded. Try this.

Code: Select all

setoutput("sample_data.csdbe|password=" + encode(PercentEncoding, "Gq26vm@5w%b&zF$E"));
Hope this helps,
Justin