Cannot create an instance of OLE DB provider "MSOLAP" for linked server "LINKED_LINK1".

• csplrj

  SSC Veteran

  Points: 243

  More actions

  April 30, 2008 at 8:44 am

  #121349

  My SQL Server is at Machine1

  My SQL Analytical Server is at Machine2

  My SQL Client is again Machine3

  I have created a linked server with the help of the following sql code

  EXEC master.dbo.sp_addlinkedserver @server = N'LINKED_LINK1', @srvproduct=N'LINK1', @provider=N'MSOLAP', @datasrc=N'192.168.2.67'

  GO

  EXEC master.dbo.sp_serveroption @server=N'LINKED_LINK1', @optname=N'collation compatible', @optvalue=N'false'

  GO

  EXEC master.dbo.sp_serveroption @server=N'LINKED_LINK1', @optname=N'data access', @optvalue=N'true'

  GO

  EXEC master.dbo.sp_serveroption @server=N'LINKED_LINK1', @optname=N'dist', @optvalue=N'false'

  GO

  EXEC master.dbo.sp_serveroption @server=N'LINKED_LINK1', @optname=N'pub', @optvalue=N'false'

  GO

  EXEC master.dbo.sp_serveroption @server=N'LINKED_LINK1', @optname=N'rpc', @optvalue=N'true'

  GO

  EXEC master.dbo.sp_serveroption @server=N'LINKED_LINK1', @optname=N'rpc out', @optvalue=N'true'

  GO

  EXEC master.dbo.sp_serveroption @server=N'LINKED_LINK1', @optname=N'sub', @optvalue=N'false'

  GO

  EXEC master.dbo.sp_serveroption @server=N'LINKED_LINK1', @optname=N'connect timeout', @optvalue=N'0'

  GO

  EXEC master.dbo.sp_serveroption @server=N'LINKED_LINK1', @optname=N'collation name', @optvalue=null

  GO

  EXEC master.dbo.sp_serveroption @server=N'LINKED_LINK1', @optname=N'lazy schema validation', @optvalue=N'false'

  GO

  EXEC master.dbo.sp_serveroption @server=N'LINKED_LINK1', @optname=N'query timeout', @optvalue=N'0'

  GO

  EXEC master.dbo.sp_serveroption @server=N'LINKED_LINK1', @optname=N'use remote collation', @optvalue=N'true'

  I have also made a setting to providers MSOLAP with the following true settings

  Dynamic Parameter--True

  Nested Queries--True

  Allow Inprocess--True

  Non transacted updates--True

  Index as access path--True

  Support like operator--True

  I get an error to the following query

  Cannot create an instance of OLE DB provider "MSOLAP" for linked server "LINKED_LINK1".

  Query

  ----------

  SELECT *

  FROM OpenQuery(LINKED_LINK1,'Select {measures.[No_transaction]} ON COLUMNS FROM [CUBE1]')

  Thanks in advance

  CSJakharia

• JayKur

  SSC Journeyman

  Points: 79

  More actions

  July 10, 2008 at 7:58 am

  #840833

  I have a similar issue.

  My openrowset syntax is as given below.

  select *

  from openrowset('MSOLAP', 'Datasource='datasource'; Initial Catalog= 'cubedb',

  'SELECT {my mdx query}')

  it works just fine. But if I modify a formula of a calculated member which is part of my MDX query , it throws the error as given below. I just don't understand the reason. Can anyone put some light on it.

  OLE DB provider "MSOLAP" for linked server "(null)" returned message "File system error: The record ID is incorrect. Physical file: . Logical file: .".

  OLE DB provider "MSOLAP" for linked server "(null)" returned message "Internal error: The operation terminated unsuccessfully.".

  Msg 7320, Level 16, State 2, Line 1