Kbase P127960: Program gets authorization failure when using ODBC DataServer to talk to non-Progress database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/3/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.x
SYMPTOM(s):
Application fails to connect due to authorization failure
Using ODBC DataServer to connect to database
ODBC Database password was changed a week ago
User can manually connect to the database via ODBC Administrator using same password
CAUSE:
Password contained characters that have special meaning within the ABL and password is hard coded into an ABL program so when the new password was entered into the ABL program and the program was recompiled the password was not what they thought it was.
FIX:
Remove special characters from password (i.e. those characters which the ABL treats specially)