Create a linked server to MPP file

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Create a linked server to MPP file

Author

Topic

fagrnada
Starting Member

1 Post

Posted - 2007-04-13 : 00:29:12

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

Mostafa Salama
M.Sc. in Computer Science

SatyaSKJ
Starting Member

46 Posts

Posted - 2007-04-18 : 05:01:49

See this blog http://hearwhat.blogspot.com/&&DI=6243&IG=672dbb2b73f24b879f074b76a8721e95&POS=2&CM=WPU&CE=1&CS=AWP&SR=1 is any help.

Satya SKJ
SQL Server MVP
http://www.sqlserver-qa.net

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources