I recieve the following error message in our asp page:

Microsoft® OLE DB Provider for Analysis Services (0x80040E14)
Formula error - syntax error - token is not valid: "
IiF(IsError^(^StrToValue([Activity type].[1])), NULL, [Activity
type].[1])"

This piece of code was running fine for 2 years prior to today. I am
able to cut and paste the MDX statement into the MDX Sample
Application on my local PC and it works fine (I'm pointing to the same
database server). But for some reason it does not work in the asp page
that resides on our production server. The provider I'm connected to
is as follows:

cn.Open "provider=MSOLAP.2;Data Source=dbname;user
id=saident;password=pw;Initial Catalog=Balanced Scorecard"

I plugged in the StrToValue to try to fix it but that did not work as
well. Any thoughts as to why this is happening?? Could it be an MDAC
issue on the server? I was told by our network folks that nothing was
updated,patched, installed on our database or web servers.

Thanks in advance!
Patrick

IsError is a VBA/Excel function
Maybe the Web server doesn't have these libraries installed or registry settings have become invalid
HTH
Bria
www.geocities.com/brianaltmann/olap.html

Thanks Brian! That was it. I took out the IsError to test it and it
worked. One last question, how can I find the appropriate
libraries/registry settings for the VBA/Excel functions? Is there an
install somewhere that includes all these functions? Is there a
particular directory the registry settings are located under? I started
looking for them, but have had no luck in finding them, or knowing which
ones I really need to look for. I was looking for Excel and/or VBA.

Thanks again for the prompt response to this!

Patrick

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

The VBA library is included with AS and it is installed by default
The Excel library is installed by Excel, and automatically registered when present in the AS machine at the time of installlation
Lookup these topics in BOL for more info

Registered Function Librarie
Register Function Libraries Dialog Bo
KB Article : PSS Id. 32296

HTH
Bria

Thanks, I wasn't sure where I needed to look. The production box was
bounced last night, and when I went in to look at this error again, it
was working. Not sure what could have happened during the restart, but
whatever it was fixed the issue. I will look into the KB article though
in case this happens again. Our network engineers had said that our
production server had not been restarted in quite sometime, so perhaps
something with these libraries was fixed due to this.

As always, much appreciated for the info!

Patrick

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!