Problems using msmdpump.dll with msolap.asp

[Daniel]

Hello!

I have set up a Win 2k3 server with IIS and SSAS2005 according to the
instructions provided by microsoft regarding webserver settings, web
extensions, web services etc.

But now I seem to get some problems, when i try to testrun the
msolap.asp page i get an error that it cant create the PUPump.PUPump1
object. My conclusions lead me to think that this was becasuse the
msmdpump.dll wasnt registred on the server, so I tried to run
"regsvr32 msmdpump.dll". At first this didnt work because I had to
provide a full path to the file, but when I provide the path I get a
new error: "msmdpump.dll was loaded, but the DllRegisterServer entry
point was not found."

Can anyone give me a hint of what I should do to get this to work?

Best regards
Daniel

[Jeje]

SSAS 2005 don't use the same XML/A system as AS2000
there is no MSOLAP.ASP file for SSAS 2005.
only the msmdpump.dll file is required.
read this for the setup:
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx

"Daniel" <d_fos...@hotmail.com> wrote in message
news:1184051197.0...@o61g2000hsh.googlegroups.com...

[Daniel]

On 10 Juli, 16:45, "Jeje" <willg...@hotmail.com> wrote:
> SSAS 2005 don't use the same XML/A system as AS2000
> there is no MSOLAP.ASP file for SSAS 2005.
> only the msmdpump.dll file is required.
> read this for the setup:http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx
>

> "Daniel" <d_fossel...@hotmail.com> wrote in message

>
> news:1184051197.0...@o61g2000hsh.googlegroups.com...
>
>
>
> > Hello!
>
> > I have set up a Win 2k3 server with IIS and SSAS2005 according to the
> > instructions provided by microsoft regarding webserver settings, web
> > extensions, web services etc.
>
> > But now I seem to get some problems, when i try to testrun the
> > msolap.asp page i get an error that it cant create the PUPump.PUPump1
> > object. My conclusions lead me to think that this was becasuse the
> > msmdpump.dll wasnt registred on the server, so I tried to run
> > "regsvr32 msmdpump.dll". At first this didnt work because I had to
> > provide a full path to the file, but when I provide the path I get a
> > new error: "msmdpump.dll was loaded, but the DllRegisterServer entry
> > point was not found."
>
> > Can anyone give me a hint of what I should do to get this to work?
>
> > Best regards

> > Daniel- Dölj citerad text -
>
> - Visa citerad text -

Oh thats strange, why do I get calls to msolap.asp in my webserver log
then?

[Jeje]

its because your client computer use the MSOLAP.2 driver (AS 2000 driver)
instead of the MSOLAP.3 (SSAS 2005) driver.

"Daniel" <d_fos...@hotmail.com> wrote in message

news:1184081242.4...@d55g2000hsg.googlegroups.com...

[Daniel]

Ok, how can I work around this. I am pretty sure that I have installed
"Microsoft OLE DB Provider for Analysis Services 9.0" on the client
computer I am testing from.

Jeje skrev:

[Jeje]

if you can play in the connectionstring, insure you setup it like:
data source=http://server/xmla/msmdpump.dll;provider=msolap.3...

sometimes regarding the applications you install, the MSOLAP.2 driver become
the main version, reinstalling the AS9 driver change the default driver to
the MSOLAP.3 version. (required if you can't selected the provider version
yourself)

"Daniel" <d_fos...@hotmail.com> wrote in message

news:1184090889.8...@k79g2000hse.googlegroups.com...

[Daniel]

Ok, thank you very much for this valuable information. I will see if I
can manage to get this to work. A final question before I continue my
work: How can I force a client computer to use the AS9 drivers as
default driver?

On 11 Juli, 04:01, "Jeje" <willg...@hotmail.com> wrote:
> if you can play in the connectionstring, insure you setup it like:
> data source=http://server/xmla/msmdpump.dll;provider=msolap.3...
>
> sometimes regarding the applications you install, the MSOLAP.2 driver become
> the main version, reinstalling the AS9 driver change the default driver to
> the MSOLAP.3 version. (required if you can't selected the provider version
> yourself)
>

> "Daniel" <d_fossel...@hotmail.com> wrote in message
>

> news:1184090889.8...@k79g2000hse.googlegroups.com...
> Ok, how can I work around this. I am pretty sure that I have installed
> "Microsoft OLE DB Provider for Analysis Services 9.0" on the client
> computer I am testing from.
>
> Jeje skrev:
>
>
>
> > its because your client computer use the MSOLAP.2 driver (AS 2000 driver)
> > instead of the MSOLAP.3 (SSAS 2005) driver.
>

> > then?- Dölj citerad text -

[Daniel]

Hi again,

I get this message from my OWC that im using to connect to the cube:

the query could not be processed:

xml parsing failed at line 1, column 9: DTD is prohibited

and my logfile in the iis server says that there has been a call made
to msolap.asp.

I get it to work if I use my internal ip-adress to browse the webpage,
but if i browse the webpage through the internet, with the same
computer, i get that message and iis log. From what I can see the call
is made through a proxy server, could it be so that the proxy is
acting as the client computer you are talking about? And how can I get
AS9 driver for Linux?

> > - Visa citerad text -- Dölj citerad text -

[Jeje]

do you use the NTLM authentication for the XMLA virtual directory?
if yes, switch to basic authentication (NTLM dislike firewalls)

again, verify the MSOLAP.3 version in the connectionstring.

for linux access, you need an XML/A compliant software to access the olap
server.
No drivers required.

"Daniel" <d_fos...@hotmail.com> wrote in message

news:1184165070.4...@m3g2000hsh.googlegroups.com...