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 |
|
CMangano
Starting Member
16 Posts |
 Posted - 2002-10-14 : 12:22:13
|
I continue to receive an error every time I try to connect to my analysis server through an ASP page. I am using the sample code entitled "aspadocubedoc.asp." The error occurs every time the code tries to connect to the analysis server. The code is:OLAPServerName = "LOCALHOST"cat.ActiveConnection = "Data Source=" & OLAPServerName & ";Initial Catalog=FoodMart 2000;Provider=msolap;" The error I get is:quote:
Microsoft OLE DB Service Components error '80004005' Unspecified error /adminfiles/cubes/aspadocubedoc.asp, line 39
Any ideas? Thanks.Chris |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-14 : 14:54:55
|
| What service pack and operating systems are involved ?HTHJasper Smith |
 |
|
|
CMangano
Starting Member
16 Posts |
Posted - 2002-10-14 : 17:24:08
|
| It's Windows 2000 with Service Pack 3.Here is an interesting note. As I have dug around some more, I noticed that if I try to choose "Microsoft OLE DB Provider for Olap Services 8.0" in the provider tab under data sources, it says "Provider is no longer available. Ensure that the provider is installed properly." So I am guessing MS Olap really isn't installed? I am looking into how to install it. If any one has some tips, please let me know. Thanks. |
|
|
|
CMangano
Starting Member
16 Posts |
Posted - 2002-10-14 : 17:41:29
|
| I figured it out...finally! Turns out I needed SP2 for Analysis Server. Once I installed it, I was able to use Olap Services 8 and the connections are working perfectly. Thanks for the help. |
|
|
|
|
|
|
Error Connection to Analysis Server In ASP