Pswrd contains # character as starting and ending character
Moderators: chulett, rschirm, roy
Pswrd contains # character as starting and ending character
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
The Connectivity Guide for that database should list how you handle that. Well, phooey... this is noted in the Oracle guide but only for column names rather than passwords. I see no such mention in the ODBC guide.
Hopefully someone else has a real answer.
Hopefully someone else has a real answer.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Assuming you know that DataStage uses the # sign to surround parameters, that's just about the worst possible choice for a password.
It is likely faster to actually have the password changed, or get your own separate ID with a compatible password, than if you were to try to convince support to produce a new enhancement or a patch, unless one is already existing.
You may also want to search the knowledge center on "password naming restrictions." The results are not specifically for the ODBC stages, however, it outlines many special characters that are not permitted for "All user IDs and passwords."
Good luck!
It is likely faster to actually have the password changed, or get your own separate ID with a compatible password, than if you were to try to convince support to produce a new enhancement or a patch, unless one is already existing.
You may also want to search the knowledge center on "password naming restrictions." The results are not specifically for the ODBC stages, however, it outlines many special characters that are not permitted for "All user IDs and passwords."
Good luck!
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray,
I replaced # with __035__ and checked but it is still not working. Our password also contains $, I replaced that too with __036__ but still getting same error message.
I am connecting to a MSSQL database using ODBC connector. For another connection, password contained $ but no hash character. This job ran successfully without any modification to password field. I see this problem arising only when we have a hash character.
Unfortunately, this database is from a third party and we have no control over the password.
Is there any work around?
Regards,
PK
I replaced # with __035__ and checked but it is still not working. Our password also contains $, I replaced that too with __036__ but still getting same error message.
I am connecting to a MSSQL database using ODBC connector. For another connection, password contained $ but no hash character. This job ran successfully without any modification to password field. I see this problem arising only when we have a hash character.
Unfortunately, this database is from a third party and we have no control over the password.
Is there any work around?
Regards,
PK
Just a correction to above post.
For the successful connection, we do have # character in the password. Password is something like $#abcd#$. This job connects to MYSQL without any modification required in password field.
It is only when password starts and ends with a #, we face this issue. We do know datastage uses ## to identify parameters, however password is set by some other team and we have no control over that.
Regards,
PR
For the successful connection, we do have # character in the password. Password is something like $#abcd#$. This job connects to MYSQL without any modification required in password field.
It is only when password starts and ends with a #, we face this issue. We do know datastage uses ## to identify parameters, however password is set by some other team and we have no control over that.
Regards,
PR
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: