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 |