Connection from cube

• ARVIND-174482

  SSC Journeyman

  Points: 86

  More actions

  December 2, 2004 at 12:40 am

  #165591

  Hi all

  The report (MDX) is running fine in the vs.net 2003 but not able to run on web browser (Report Server). Am I missing some software or upgrades/ connection string. I am on client(professional 2000) and the server is windows 2003.

  The error says

  An error has occurred during report processing. (rsProcessingAborted) Get Online Help

  • Cannot create a connection to data source 'FoodMart 2000'. (rsErrorOpeningConnection) Get Online Help

    • The 'MSOLAP.2' provider is not registered on the local machine.

      • No error information available: REGDB_E_CLASSNOTREG(0x80040154).

  The other reports  are running fine through the reportserver.

  Thanx in advance.

  regards

  Arvind Sharma

   

• December 6, 2004 at 8:00 am

  This was removed by the editor as SPAM

• David Su

  SSC Veteran

  Points: 206

  More actions

  December 6, 2004 at 2:10 pm

  #532754

  In Shared Data Source the setting something like that

  Type : OLE DB

  Connection string:

  Provider=MSOLAP.2;Client Cache Size=25;Data Source=localhost;Auto Synch Period=10000;Initial Catalog=FoodMart 2000

  I think the data source you have to point to the OLAP Server.

   

   

• Vishal Singh

  SSCertifiable

  Points: 5830

  More actions

  June 17, 2009 at 4:32 am

  #1010745

  Any resolution so far...I am also trying to migrate a SSAS 2000 DB to 2005 and I am getting the same error...

  -Forum Etiquette: How to post Performance Problems[/url]

  -Forum Etiquette: How to post data/code to get the best help [/url]