Jessica C wrote:
> *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 *

"Paul S" <Paul.S.1rmx90@mail.webservertalk.com> wrote in message
news:Paul.S.1rmx90@mail.webservertalk.com...
>
> Hi Jessica
>
> I have EXACTLY the same problem and It's driving me nuts!! Exactly the
> same situation as yourself, accessing an olap database via a linked
> server using ole db, same error... If you found a solution I would
> appreciate any pointers..
>
> Regards
>
> Paul
>
>
> Jessica C wrote:
>> *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 *
>
>
>
> --
> Paul S
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message1107834.html
>

"Jessica C" wrote:

> The solution is there is no solution. :(
>
> It is due to a bug in sp4... Microsoft is aware of the problem, we have an
> open ticket with them, and in the next QuickFix there is suppose to be a fix
> for it though I haven't heard anything about when that will be.
>
> "Paul S" <Paul.S.1rmx90@mail.webservertalk.com> wrote in message
> news:Paul.S.1rmx90@mail.webservertalk.com...
> >
> > Hi Jessica
> >
> > I have EXACTLY the same problem and It's driving me nuts!! Exactly the
> > same situation as yourself, accessing an olap database via a linked
> > server using ole db, same error... If you found a solution I would
> > appreciate any pointers..
> >
> > Regards
> >
> > Paul
> >
> >
> > Jessica C wrote:
> >> *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 *
> >
> >
> >
> > --
> > Paul S
> > ------------------------------------------------------------------------
> > Posted via http://www.webservertalk.com
> > ------------------------------------------------------------------------
> > View this thread: http://www.webservertalk.com/message1107834.html
> >
>
>