Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Unable to register msolap90.dll


Unable to register msolap90.dll

Author
Message
dbman
dbman
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 1537
Hello,

I am using SQL Server Data tools. I have been working on a Microsoft tutorial on teaching you build SSAS cubes. I have now go the point where I want to browse the cube via Excel. When I clicked on the Analyze in Excel button I saw the message:

"Initialization of the data source failed. Check the database server or contact your database administrator. Make sure that the external database is available, and then try the operation again"


I googled the message and found a solution which was:

Checked if the 9.0 Ole DB provider was properly registered on the client pc. I decided not to take any risk and just re-register the dll-file. I used the following command in the command line to accomplish this step:

regsvr32 "c:\windows\program files\common files\system\ole db\msolap90.dll"

This final step solved the issue, after re-registrating the dll-file on the client computer, the user was able to open the pivottable of the SQL server cube.

So after following those instruction I got the message:

The module cd failed to load. Make sure the binary is stored at the specified path or debug
it to check for problems with the binary or dependent .DLL files.

The specified module could not be found.

"c:\program\files\commonfiles\system\oledb\msolap90.dll"

I searched the directory and noticed that the actual file msolap90.dll wasn't there.


I am using Windows 8 64bit. Does anyone know where I can obtain this file from?

Regards
dbman
dbman
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 1537
Any ideas anyone?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search