OLEDB provider error.

Hot Topic

Understanding RS Security
Can we change table structure in Mirroring
Problem with View migrated from SQL Server 2000 into 2005
Cannot Display result or Submit SQL statment contains Thai Character via ODBC
Problem activating a server on home PC
Query rerading the Excel Addin related to MSOALP Cubes
Metadata Issues
AMO Connection
Can't install SSIS on an XP machine
Relationships problem in Sql Server 2000

SQL Server

SQL Server Data Archiving
Use Command or BCP for large SQL statement
URL rending vs embedded reports
Page break after X items
Using Transactions causes database connection to fail
Load a SSIS package via Web Service: The package failed to load due to error 0xC0011008 "Error loading from XML.WHAT IS THAT?
Virtual Labs - No Connection message
Analysis Services Taking Forever and Over 800MB Memory....
How to make a diagram from data in a SQL Server table?
regrouping hierarchies

OLEDB provider error.

Hi:

I have created a cube and deployed in sql server. I am trying to connect to analysis services to access cube with linked server. I am getting this error...how do i fix this.

OLE DB provider "MSOLAP" for linked server "(null)" returned message "Errors in the OLE DB provider. The Extended Properties property is set to a value that is not supported.".

Msg 7373, Level 16, State 2, Line 1

Cannot set the initialization properties for OLE DB provider "MSOLAP" for linked server "(null)".

Thanks,

Pramod


Answer this question

OLEDB provider error.

  • Naokazu Tsukada

    Just leave it blank like this: Extended Properties="".
    What's your whole connection string
    Thanks.



  • Frustrated1689

    Xinwei:

    Extended properties for my database is null...

    Thanks,

    Pramod



  • rileyjim

    Yep...it didnt help

  • Achelon

    Xinwei:

    This is the query i am using...

    SELECT a.* FROM OPENROWSET( 'MSOLAP','DATASOURCE=PKUMAR\PKUMAR;

    Initial Catalog=Analysis Services Project1;', 'SELECT Measures.members ON ROWS,

    [Product Category].members ON COLUMNS FROM [Adventure Works Internet Sales]') as a

    go

    Thanks,

  • helpmeimstupid

    What's your Extended Properties Please check whether there is any typo.

  • wromee

    The problem is on the Extended Properities as the error msg stated. If you have nothing to specify, please try delete it.

  • gwc

    I am moving this to the SQL Server Analysis Services Forum.

  • OLEDB provider error.
Answer this question