telventaustralia

The OLE DB provider "PIOLEDB" for linked server "PI" reported an error. Access denied.

Discussion created by telventaustralia on Aug 13, 2009
Latest reply on Aug 17, 2009 by telventaustralia

Hi

 

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
The OLE DB provider "PIOLEDB" for linked server "PI" reported an error. Access denied.

 

Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB provider "PIOLEDB" for linked server "PI".

 

 

 

 

Thanks in advance for your help
Mauricio

Outcomes