Kbase 19784: Error 709 occurs when performing a test ODBC connection
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/02/2007 |
|
Status: Unverified
SYMPTOM(s):
Error 709 occurs when performing a "test connection" with ODBC Datasource.
** -P and -U startup parameters require _User file records. (709)
SQL-92 Engine
CAUSE:
The error occurs if an incorrect User ID and/or password is entered
FIX:
Follow these steps to correct the configuration:
1) Log into the database with administration rights and add a
user called sysprogress. This user is the same as the
administrator for Progress.
2) Log into the database with prowin32 (dbname) -1 -p admin.p,
for example from the command prompt to get into the
Data Administration tool.
3) From the Admin tab, select Security >Edit User List.
4) Create a new user called sysprogress and assign a password for
the user. Type the password once more when you are prompted.
5) Log on as sysprogress and and create new users of the
database.
You must grant each user specific rights to allow each to see the tables when you use an external program to extract data from the Progress database by means of the ODBC driver. If you cannot extract data, erase the UserID or password you added to the Table. In the ODBC administrator, leave the user name and password fields blank (to match the empty records in the table) then make a connection.