ODBC Progress Driver Errors within Access 2003
Posted on 2010-11-19
I recently had a new DataDirect ODBC Progress OpenEdge Wire Protocol driver installed in order to use data from a Progress database in an Access 2003 database.
I used to be able to access the data in a Progress database no problem, but now I get errors. I have no problem using the driver with Crystal Reports (although I was having a problem which was solved by changing the username in my ODBC connection).
When I run a query that uses a linked table in Access that used to work fine, I get the following error:
ODBC - call failed. [datadirect][odbc progress wire protocol driver][openedge]Access denied (authorization failed)(7512)(#-20228).
If I try to re-link the tables through Linked Table Manager, or try to create a new database linking to the tables I get this message:
Reserved error (-7748); there is no message for this error.
I have looked around at various sites but can't find a solution that fits me. Help!
Thank you Experts!!