dbTalk Databases Forums  

MDAC 2.8 Problems with ADOMD

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss MDAC 2.8 Problems with ADOMD in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andres
 
Posts: n/a

Default MDAC 2.8 Problems with ADOMD - 11-11-2005 , 07:29 AM






Hi all,
I hope this time i can get a solution.
I'm geting an error after install a SP4 for SQL Server and analysis services
on the server.the box have a windows 2K SP4, with SQL 2000 based version,
analysis services 2000 based version and IIS 5 installed.
My app (an ASP app) was working fine with the cube, but I ca'nt use the
username propertie of the Analysis services to implement dynamic security.
After I read a lot of articles from Microsoft, I arrived to the conclution
that my server does'nt have the SP4 for SQL Installed. In fact it was'nt
installed.
I install the SP fro SQL and analysis services and after that I'm geting the
folowing error when I try to createObject("ADOMD.CellSet"), the error is
simple, strong and clear as the water: "
Server object error 'ASP 0177 : 8002801d'

Server.CreateObject Failed

/includes/functions_MDX.asp, line 17

Library not registered.
"

Library not registered? Why? what happend?
I run de component Checker on the server and MDAC is installed with 2.8 for
win xp SP2 version.
I was looking everywhere for a solution but i can't find it.
Pls any sugestion

Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: MDAC 2.8 Problems with ADOMD - 11-13-2005 , 05:55 PM






The ADOMD library is not a part of the core MDAC, it is part of what is
referred to as PTS (Pivot Table Services).

You could try re-registering the file manually, by going to C:\Program
Files\Common Files\System\ado and running "regsvr32 msadomd.dll". If
this does not work there is a file that is part of SP4 called
PTSLite.exe. Run this on your client and it should re-install and
register all of the PTS components.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <2B2652D5-80EB-470E-A204-FE45F3EA7ADA (AT) microsoft (DOT) com>,
Andres (AT) discussions (DOT) microsoft.com says...
Quote:
Hi all,
I hope this time i can get a solution.
I'm geting an error after install a SP4 for SQL Server and analysis services
on the server.the box have a windows 2K SP4, with SQL 2000 based version,
analysis services 2000 based version and IIS 5 installed.
My app (an ASP app) was working fine with the cube, but I ca'nt use the
username propertie of the Analysis services to implement dynamic security.
After I read a lot of articles from Microsoft, I arrived to the conclution
that my server does'nt have the SP4 for SQL Installed. In fact it was'nt
installed.
I install the SP fro SQL and analysis services and after that I'm geting the
folowing error when I try to createObject("ADOMD.CellSet"), the error is
simple, strong and clear as the water: "
Server object error 'ASP 0177 : 8002801d'

Server.CreateObject Failed

/includes/functions_MDX.asp, line 17

Library not registered.
"

Library not registered? Why? what happend?
I run de component Checker on the server and MDAC is installed with 2.8 for
win xp SP2 version.
I was looking everywhere for a solution but i can't find it.
Pls any sugestion


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.