Kbase P156752: How to create blank user password for SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/2/2009 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
1. Go into database admin tool, add a user (say "test") with blank password, also add a user called "sysprogress" with a password
2. Use any sql client (I used sqlexp), connect to db as sysprogress and password created in step1 , grant some privilege to "test" , make sure you commit
3. Disconnect sqlexp, reconnect using test and blank password, it should connect, you should also be able to run sql queries on the tables you have privileges on
4. Using ODBC driver for Progress, connecting using "test" and blank password also works at this point