Pswrd contains # character as starting and ending character
Posted: Thu Dec 04, 2014 5:46 pm
Hi All,
My password is having # as a starting character and as an ending character (e.g. password is like #abcd$#). I am using ODBC connector stage to connect to a SQL Server database.
I am getting below error:
Invalid property value /Connection/Password (CC_StringProperty::getValue, file CC_StringProperty.cpp, line 109)
I tried following things after reading through IBM website:
1) Enclosed password in double quotes and checked ("#abcd$#")
2) Enclosed password in double quotes and escaped special characters in password string ("\#abcd\$\#")
3) Enclosed password in double quotes and escaped special characters in password string except # strings in the start and in the end ("#abcd\$#")
For all the above cases, I get an error message:
ODBC function "SQLConnect" reported: SQLSTATE = 28000: Native Error Code = 18456: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver][SQL Server]Login failed
Password cannot be changed.
Regards,
PR
My password is having # as a starting character and as an ending character (e.g. password is like #abcd$#). I am using ODBC connector stage to connect to a SQL Server database.
I am getting below error:
Invalid property value /Connection/Password (CC_StringProperty::getValue, file CC_StringProperty.cpp, line 109)
I tried following things after reading through IBM website:
1) Enclosed password in double quotes and checked ("#abcd$#")
2) Enclosed password in double quotes and escaped special characters in password string ("\#abcd\$\#")
3) Enclosed password in double quotes and escaped special characters in password string except # strings in the start and in the end ("#abcd\$#")
For all the above cases, I get an error message:
ODBC function "SQLConnect" reported: SQLSTATE = 28000: Native Error Code = 18456: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver][SQL Server]Login failed
Password cannot be changed.
Regards,
PR