Kbase P14010: Passwords with # symbol (shift -3) cause problem accessing database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/11/2006 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
Progress 8.x
SYMPTOM(s):
CONNECT statement is used in procedure editor and in code
CONNECT statement contains userid and password
# symbol used in password will not permit access to the database
CAUSE:
The pound sign (#) is used as a special character to comment a line in a Progress .pf file and there will not work in CONNECT statements via Data Dictionary or Procedure Editor.
The pound sign will work via command line access:
Prowin32 sports -1 -S port -H host -U user1 -P user1#
FIX:
To use the # symbol in a CONNECT statement:
1. Use double and single quotes on Windows.
Windows: CONNECT testdb -1 VALUE("-U user1 -P 'user1#' ").
2. Use the escape character on UNIX.
UNIX: CONNECT testdb -1 -U user1 -P user1\\# or -P user1~~#