I'm having a really wierd problem. I'm not sure if it is Database related, Server related or a problems with my SQL Tools. While trying to access a linked server, I am receiving the following error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'IBMDADB2' reported an error. Access denied.
OLE DB error trace [OLE/DB Provider 'IBMDADB2' IUnknown:
ueryInterface returned 0x80070005: Access denied.].
I am trying to access a DB2 database on our mainframe after setting it up as a linked server. This has been working in the past but has stopped for some reason.
I can login to the mainframe and run a query from within my 3270 session without problems. DB2 Connect is installed and I can run queries through Command Center. A program that I have written accesses the System Data source and can acces the mainframe without problems. It is only when I try and connect through my linked server that I receive an error.
Any help would be REALLY appreciated!