Linked Server w/ VFPOLEDB
I created a linked server with vfpoledb.dll. It works if I log into the server as our primary system administrator ID but I get an access denied error when I log in as myself. I have system administrator right set up for my ID so I don't understand the problem. This is the error I get:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'VFPOLEDB' reported an error. Access denied.
OLE DB error trace [OLE/DB Provider 'VFPOLEDB' IUnknown::QueryInterface returned 0x80070005: Access denied.].
Your help is appreciated.