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

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?

Answer 1

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]

Answer 2

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] ".

Answer 3

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]

Answer 4

I feel that it is necessary to write CAST correctly, but How.?

Answer 5

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.

Answer 6

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 [e-mail].

Answer 7

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