dbTalk Databases Forums  

OLE DB Connection

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss OLE DB Connection in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jessica C
 
Posts: n/a

Default OLE DB Connection - 06-21-2005 , 04:16 PM






Hi

I have a stored proc that uses a linked server connection to a cube and
after applying sp4 I get the following error when running the sproc:

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


If any one has any suggestions, I would apprieciate it very much... they
query worked fine up until applying sp4.

Thanks! Jessica



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.