Kbase P19792: Odbc connection fails with ODBC Test Connect error:[] Access denied/Authorization failed. (8933)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/04/2006 |
|
Status: Unverified
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
Problem establishing an ODBC connection to the database.
Attempting connection from machine where database resides.
Database resides on local drive
database started with -H and -S parameters.
ODBC Test Connect error:[] Access denied/Authorization failed. (8933)
mpro dbname -p dict.p prompts for user name
CAUSE:
Database security was enabled, meaning that the Progress database _User table is not empty, SQL-92 users will get Driver Access Denied errors if the user in question has no been added to _user table.
FIX:
The Database Administrator needs to:
1. Add the sysprogress user to the _user table.
2. Connect to the database using sysprogress.
3. Grant permissions to the login names used by the users.
4. Remove the sysprogress user in the _User table.
5. Provide users with login credentials.
For more information on this area, please refer to Progress Solution: 20143 "Basic Guide to Defining Progress SQL-92 Database Permissions & Security"