Password

Discussions about editing and cleaning data
Post Reply
YFT_CBSD
Posts: 54
Joined: January 3rd, 2023, 12:36 am

Password

Post 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.
justinlakier
Posts: 238
Joined: November 21st, 2022, 4:41 pm

Re: Password

Post 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
Post Reply