HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.olap » Linked Server Error: 'MSOLAP' did not provide an appropriate inter
Topic: Linked Server Error: 'MSOLAP' did not provide an appropriate inter
SQL 2000 SP4 with AS 2000 SP4.
Create linked server to FoodMart 2000 OLAP DB called "FOODMART".
No problem to execute query (note no "on Rows"):
SELECT *
FROM OPENQUERY(FOODMART, 'select {[Measures].Members} ON COLUMNS
FROM Warehouse'
But for query:
'select
{[Measures].Members} ON COLUMNS,
Descendants([Store].[All Stores].[USA], [Store].[Store City]) ON ROWS
FROM Warehouse'
get error:
Could not execute query. The OLE DB provider 'MSOLAP' did not provide an
appropriate interface to access the text, ntext, or image column
'[MSOLAP].[Store].[Store Name].[MEMBER_CAPTION]'.
I see old threads about this and last psotings say:
1. Bug introduced in SP4.
2. Quick Fix coming.
3. Without fix, need to roll back SP4.
Anything new on this to report?
Les
Replies below ↓