IIS DataPump / msolap.asp named pipe transport

[Markus Stehle]

Hi all!

I'm using a OWC10 pivot table and chartspace in an asp.net page (client side
controls). The data source for the pivot table is an OLAP cube. The cube is
hosted on an Analysis Server that is not the web server and has to be
accessed via the internet. So I configured the webserver to use the IIS data
pump library as described here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/sql_datapump.asp

The connection string within my pivot table looks like this:
Provider=MSOLAP.2;Integrated Security=SSPI;Persist Security Info=False;Data
Source=http://myserver.com/datapump;Initial Catalog=MyDB;Client Cache
Size=25;Auto Synch Period=10000

I modified msolap.asp to use named pipe transport by specifying:
pump.ServerName = "myServer"

Whenever I access my asp.net page, the pivot table displays the error
"database MyDB does not exist". So I installed Analysis Services on the web
server together with the FoodMart 2000 sample and changed the database name
in the connection string in my asp.net page to "FoodMart 2000". Then it
works, so it seems as if the named pipe transport does not work.When
creating a database named "MyDB" on the webserver it also works.

Any ideas?


Thanks

Markus