Hi!

After installing of the SP4 on both SQL SERVER and AS (They are both on the
same box).
I can't execute any MDX-Query through OPENQUERY

I get following message from SQL Serever

Server: Msg 7358, Level 16, State 1, Line 1
Could not execute query. The OLE DB provider 'MSOLAP.2' did not provide an
appropriate interface to access the text, ntext, or image column
'[MSOLAP.2].[Store].[Store Country].[MEMBER_CAPTION]'.
OLE DB error trace [Non-interface error: Could not get a storage interface
for BLOB the column: ProviderName='MSOLAP.2' TableName='[MSOLAP.2]',
ColumnName='[Store].[Store Country].[MEMBER_CAPTION]'].



Befor SP4 it have run without problem

You can make following test

EXEC sp_addlinkedserver
@server='srv_olap',
@srvproduct='',
@provider='MSOLAP.2',
@datasrc='localhost',
@catalog='foodmart 2000'
go

select * from openquery(SRV_OLAP, 'SELECT { Time.Year.[1997] } ON COLUMNS,
NON EMPTY Store.MEMBERS ON ROWS
FROM Sales
WHERE ( Product.[Product Category].[Dairy] )')

I am experiencing exactly the same problem. Have you had any success in
finding a solution/workaround?

Hi,

Me too. But at this time I think I´m rolling back SP4. The problem is that
this SP solves some problems here. If anybody find any solution, please let
me know, it´s realy very important to me.

TIA

Alexandre

"neil.foster" wrote: