Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gdeconto
Posting Yak Master
107 Posts |
 Posted - 2002-08-27 : 15:22:25
|
| I am trying to create a linked server on a test win2k sql2k (with win2k sp3, sql2k sp2 and sql2kasp sp2)For some reason, the Provider Name listbox does NOT show these two vital entries:1. Microsoft OLE DB Provider for OLAP Services2. Microsoft OLE DB Provider for Olap Services 8.0It does show the data mining provider.I have tried:1. reinstalled SQL and all the service packs2. reinstalling OLAP and all the service packs3. registering the MSOLAP.DLL and MSOLAP80.DLL4. checking the ms website and other newsgroups for info (nothing on this item)Any help or ideas would be appreciated.thx in advance. |
|
|
gdeconto
Posting Yak Master
107 Posts |
Posted - 2002-08-27 : 15:35:50
|
| Note that I was able to setup another server (our live one) with OLAP and it correctly displays the OLAP providers in the list box.p.s. Is anyone else having as much trouble with setting up OLAP for use as I have been having. It has been one pain in the butt after another. I probably could have MANUALLY summarize the 3 million data records myself using a calculator... |
 |
|
|
|
|
|
all olap services missing for new linked servers