locked
Failed to initialize the OLE DB provider data source object "MSOLAP.7" for linked server "(null)". RRS feed

  • Question

  • I create query

    SELECT 
     CAST(F1."[Торговые точки].[Группа ТТ].[Группа ТТ].[MEMBER_CAPTION]" AS NVARCHAR(200)) AS [Группа ТТ], 
     CAST(F1."[Measures].[Отгрузки шт]" AS float) AS [Отгрузки шт] 
    FROM
    OPENROWSET(
     'MSOLAP.7',
     'Provider=MSOLAP.7;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=profit;Data Source=salesstorage.hlebprom.ru;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error',
     'SELECT
      [Measures].[Отгрузки шт] ON 0,
      [Торговые точки].[Группа ТТ].[Группа ТТ]  ON 1
      FROM PROFIT'
     ) AS F1

    when i run it, i get the error

    Failed to initialize the OLE DB provider data source object "MSOLAP.7" for linked server "(null)".

    What does it mean and how to fix it?

    Friday, January 18, 2019 11:27 AM

All replies

  • Provider=MSOLAP.7;


    Is that data Provider installed on the machine where SQL Server is running? .7 means there are 7 different Version of MsOlap installed; can't believe it. Use only "MSOLAP" without Version number.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, January 18, 2019 12:27 PM
  • Provider=MSOLAP.7;


    Is that data Provider installed on the machine where SQL Server is running? .7 means there are 7 different Version of MsOlap installed; can't believe it. Use only "MSOLAP" without Version number.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Olaf Helper, i did it. Use only "MSOLAP" without Version number.

     CAST(F1."[Торговые точки].[Группа ТТ].[Группа ТТ].[MEMBER_CAPTION]" AS NVARCHAR(200)) AS [Группа ТТ],  
     CAST(F1."[Measures].[Отгрузки шт]" AS float) AS [Отгрузки шт] 
    FROM
    OPENROWSET(
     'MSOLAP.7',
     'Provider=MSOLAP;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=profit;Data Source=salesstorage.hlebprom.ru;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error',
     'SELECT
      [Measures].[Отгрузки шт] ON 0,
      [Торговые точки].[Группа ТТ].[Группа ТТ]  ON 1
      FROM PROFIT'
     ) AS F1

    then error

    Failed to read storage object from OLE DB provider "MSOLAP.7" for linked server "(null)", table "[MSOLAP.7]", column "[Outlets]. [TT Group]. [TT Group]. [MEMBER_CAPTION] ".

    Friday, January 18, 2019 12:39 PM
  • OPENROWSET(
     'MSOLAP.7',
     'Provider=MSOLAP;


    The first parameter is the used provider Name and it's still with the version

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, January 18, 2019 12:46 PM
  • I feel that it is necessary to write CAST correctly, but How.?
    Friday, January 18, 2019 12:48 PM
  • OPENROWSET(
     'MSOLAP.7',
     'Provider=MSOLAP;


    The first parameter is the used provider Name and it's still with the version

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    if I remove the 7, it gives an error
    The MSOLAP 32-bit OLE DB provider cannot be loaded as in-process on a 64-bit version of SQL Server.
    Friday, January 18, 2019 1:05 PM
  • if I remove the 7, it gives an error
    The MSOLAP 32-bit OLE DB provider cannot be loaded as in-process on a 64-bit version of SQL Server.

    Hi merzavazeh,

    You could try to solve this issue by referring to the two articles.

    Invoke-Sqlcmd : The 32-bit OLE DB provider "MSOLAP" cannot be loaded in-process on a 64-bit SQL Server

    32-BIT OLE DB PROVIDER “MSOLAP” CANNOT BE LOADED IN-PROCESS ON A 64-BIT SQL SERVER

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, January 21, 2019 6:47 AM
  • OPENROWSET(
     'MSOLAP.7',
     'Provider=MSOLAP;


    The first parameter is the used provider Name and it's still with the version

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    if I remove the 7, it gives an error
    The MSOLAP 32-bit OLE DB provider cannot be loaded as in-process on a 64-bit version of SQL Server.

    Try the solution specified here

    https://blogs.technet.microsoft.com/mdegre/2012/08/18/invoke-sqlcmd-the-32-bit-ole-db-provider-msolap-cannot-be-loaded-in-process-on-a-64-bit-sql-server/


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Monday, January 21, 2019 6:57 AM