Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to register msolap90.dll Expand / Collapse
Author
Message
Posted Wednesday, June 26, 2013 3:37 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 2:35 PM
Points: 110, Visits: 1,469
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

Post #1467890
Posted Friday, June 28, 2013 2:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 2:35 PM
Points: 110, Visits: 1,469
Any ideas anyone?
Post #1468466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse