Excel 2007 on 32Bit Win7 -Connect to- SSAS 2008 on 64Bit Win2008 Ent

• michael.wxm

  Valued Member

  Points: 56

  More actions

  March 11, 2010 at 2:47 am

  #219789

  Tried many ways,all failed finnally.

  I'd intalled Office 2007 on the SSAS 2008 server, it works.

  I followed the odc from server,but it didn't work on my 32 Bit Win7.

  I found a error log followed:

  <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

  <System>

  <Provider Name=".NET Runtime" />

  <EventID Qualifiers="0">1022</EventID>

  <Level>2</Level>

  <Task>0</Task>

  <Keywords>0x80000000000000</Keywords>

  <TimeCreated SystemTime="2010-03-11T09:20:00.000000000Z" />

  <EventRecordID>6339</EventRecordID>

  <Channel>Application</Channel>

  <Computer>Michael-PC</Computer>

  <Security />

  </System>

  <EventData>

  <Data>.NET Runtime version 2.0.50727.4927 - Failed to CoCreate profiler.</Data>

  </EventData>

  </Event>

  And here is my ConnectionString:

  <odc:ConnectionString>Provider=MSOLAP.4;Password=******;Persist Security Info=True;User ID=******;Data Source=tfs;Initial Catalog=Tfs_Analysis</odc:ConnectionString>

  sb help me ,thks.

• michael.wxm

  Valued Member

  Points: 56

  More actions

  March 12, 2010 at 1:45 am

  #1132512

  Firwall !! no words to say.