I obtained one test asp from the Microsoft web site that runs an OLAP query.
The ASP sits on the Web Server and is able to connect and retrieve cube data
from a different server. However, this ASP has hard coded server, database
and query statements. When I try to achieve the same objective with
different ASPs provided by MS that use information submitted through a form,
I get either connection errors or ASP syntax errors. I am not sure how to
fix these problems, since MS makes it sound like the ASPs are ready to run.
I already installed OLAP Client on the web server, and I can browse OLAP
data from the Web server. I guess I have some connection and syntax
problems I need to correct, but I just don't have sufficient knowledge to
fix them. I am also a bit confused since the ASPs don't access the database
in the same way ODBC does. Any suggestions?