dbTalk Databases Forums  

Failure in proccessing OLAP cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Failure in proccessing OLAP cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Kr
 
Posts: n/a

Default Failure in proccessing OLAP cube - 10-08-2004 , 12:03 PM






I am having difficulty in the final stage of the OLAP
cube Wizard. I attempted to follow the tutorial in the
creation of an OLAP cube for the FoodMart database
example, and at the very end, it fails to proccess. I am
able to set up the Data Source, build the dimensions,
view the contents, and edit the cube. In the design
storage phase I reach the very end, where I get error
messages in the proccessing phase.

The messages read:
[Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed;IM006; Time:10/8/2004 9:56:48 AM

I have been trying to fix this for some time, I cannot
get it to work. I am running Windows XP, SQL server 2000
and Analysis Services with Service Pack 3a on both. My
Data Sources(ODBC) is configured as the tutorial
described, with a Microsoft Access Driver for the
FoodMart database.

I am also an administrator on this machine, which
includes being a member of the OLAP administrators group.

Any suggestions?
Thanks,
Michael Kr

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.