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.
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.
See KB-entry http://progress.atgnow.com/esprogress/resultDisplay.do?gotoLink=130&docType=1006&contextId=18234%3A130.160&clusterName=CombinedCluster&contentId=550451b7-9a6d-4d0f-985e-34c94d08ac6c&responseId=4f2e6f6f8c3365a4%3Ab60b93%3A10f6eed9087%3A-842&groupId=3&answerGroup=2&score=873&page=http%3A%2F%2Fprogress.atgnow.com%2Fesprogress%2Fdocs%2FSolutions%2FProgress%2FESERVER_P5065.xhtml&result=1&excerpt=Connectingassysprogress+user&resultType=5002#Goto130