none
run openquery(mdx) through a linked server

    Domanda

  • Hi,

    I run openquery() from a client application(sql 2005) to query SSAS data(sql 2005) through a linked server(sql 2005), but I get the following error:

    OLE DB provider "MSOLAP" for linked server "LINKEDMINING" returned message "An error was encountered in the transport layer.".
    OLE DB provider "MSOLAP" for linked server "LINKEDMINING" returned message "The peer prematurely closed the connection.".
    Msg 7303, Level 16, State 1, Procedure gettpdt, Line 3
    Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "LINKEDMINING".

    And, I am sure that I have made the MSOLAP provider Allow inprocess.

    What can i do for this. Please advise.

    mercoledì 15 novembre 2006 04:31

Risposte

Tutte le risposte