Progress ODBC Driver

Posted by David_Kettlewell on 10-Dec-2006 18:11

I am trying to connect to our Progress databases using the Progress ODBC driver. We have our databases hosted on a UNIX server, and I am trying to connect from a windows desktop.

The connection reports that it connects correctly. Using MSAccess as a client, I can see the tables, and link to them ok, but I cannot actually look at the data. An error is raised:

"ODBC Call failed"

"..... Access denied (Authorisation failed...."

Our databases do not use the progress security (security is managed by UNIX and with internal features), so I can connect using provision, or via a character client, and in either case access the data. Why not via ODBC?

I reckon there is some vital point I am missing.

Any help would be appreciated.

All Replies

Posted by Admin on 11-Dec-2006 01:23

This is explained in the documentation somewhere (and in the knowledge base). You have to define user "sysprogress" with a password in the 4GL Data Administration tool. If I recall well you can also use the user/password that created the database. When you have "sysprogress", you can grant access to other users/tables.

Posted by Admin on 11-Dec-2006 01:25

See KB-entry

This thread is closed