I have an SQL database that connects to a Progress database using linked servers with a DSN. The DSN uses datadirect drivers. When in SQL, I query Progress and I get the data just fine if I use the credentials of sysprogress user. However if I use anything but sysprogress I get an error:
OLE DB provider "MSDASQL" for linked server " returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Access denied (Authorization failed) (7512)".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "select * from pub.abccode" for execution against OLE DB provider "MSDASQL" for linked server.
Has anyone ever seen this?