Member Avatar for pen2satya

I have Sql server 2000 personal edition which i always use.But today when i tried to copy the while CD to my system,every files are copied except (msolap which is 97.1 MB size).Can anyone please tell me the link where i can get msolap fresh copy for this particular Personal Edition ?

  • 2 Contributors
  • 2 Replies
  • 129 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by pen2satya

Dani AI

Generated

Short answer for : the CD's "msolap" folder is the full installer package for the Analysis Services OLE DB provider (setup, CABs and support files). Replacing only the single DLL will not recreate the installer or the registry/integration the installer creates. The two practical paths are (A) recover the original folder from the disc, or (B) get the matching redistributable from Microsoft for SQL Server 2000 (MSOLAP 8.0) and run its setup.

Recommended recovery steps

Try a resilient copy first. On Windows, run a copy that preserves hidden/system files and continues on errors:

xcopy D:\msolap C:\SQL2000\msolap /E /C /H /K /I

If you have Robocopy available, it is more robust:

robocopy D:\msolap C:\SQL2000\msolap /MIR /R:2 /W:5

If the disc produces read errors, make an ISO image of the CD and extract the folder from the image. If the CD is scratched, use a CD recovery/imaging tool to pull as much data as possible. If recovery fails, download the official Microsoft OLE DB Provider for Analysis Services that matches SQL Server 2000 (MSOLAP 8.0) from Microsoft and run its installer rather than copying a lone DLL.

Troubleshooting notes

Check the copy log for the exact error. Do not attempt to "fix" by only copying msolap.dll and running regsvr32 — the provider installer writes required registry entries and installs other helpers. After recovery, run the provider's setup.exe from the recovered folder. Create an ISO backup of the CD once you succeed to avoid repeating this.

Recommended Answers

All 2 Replies

Member Avatar for airbourne

That seems awfully big for a DLL. The only ones I can find by using Google are less than 10 MB. If you know the exact version of the dll, you might be able to find it in an online file repository. Just search Google for MSOLAP download.

Member Avatar for pen2satya

Hi airbourne,
I didn't find what i wanted, tha't why i posted it here.I first searched it in google and i also knlw it's a dll file having less size.But i have SQL server 2000 Personal Edition CD in which the folder msolap size is 97.1 MB.
I want that the whole 97.1 MB folder back not the only less sized versatile msolap.dll file.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.