Monday, March 19, 2012

Could not obtain a required interface error

I have created a linked server that connects to "mpp" file, and it connects and opens successfuly returning a list of tables that exists in the linked server to the mpp file.

But the problem i am facing now that whne i write a select statment to get data from the tables in this linked server

select * from linktompp.testmpp.dbo.tasks

such that linktompp is the linked server name

testmpp is the catalog name

tasks is the table name i need to select data from

it shows an error that says

"Could not obtain a required interface from OLE DB provider 'Microsoft.Project.OleDB.11.0'."

"[OLE/DB Provider 'Microsoft.Project.OleDB.11.0' IUnknown::QueryInterface returned 0x80004002: IGetDataSource]"

could anyone tell me the reason of this error

thanks

Hi my friend

I try to insert data into MSP

i can select data from MSP and show into datagrid

but now i coulde not insert data

i live in Iran,you can call to me with Email:jazayery@.gmail.com

Best Reagard

No comments:

Post a Comment