I am testing PI OLE DB provider so I created a PI linked server from SQL server express but when I tried to query it I got an error Message. Could someone please tell me what is that error about? How could I fix it?
But the way , I couln't set the Provider Properties( Dynamic Parameters, Nested Queries and Allow InProcess) because I couldn't find the properties dialog box or any stored procedure to do it. Could it be the reason? how can I set them?
Msg 7399, Level 16, State 1, Line 1 Msg 7301, Level 16, State 2, Line 1
The OLE DB provider "PIOLEDB" for linked server "PI" reported an error. Access denied.
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB provider "PIOLEDB" for linked server "PI".
Msg 7301, Level 16, State 2, Line 1
Thanks in advance for your help