Export to Excel option in Pivot Table list giving connection errors. -
11-11-2004
, 07:32 AM
Dear All,
I have developed a web-based solution for OLAP reporting using ASP.Net and OWC components (Pivot Table List). My ASP.Net page communicates to the Analysis Server via http mode. Now, when I try to export to Excel from my web page, it gives me the following message: Cannot connect to http://myservername/mywebsitename..And if I go one step ahead saying next, it gives me error OLAP error: Cannot connect due to network problems.
Actually, my webserver, Analysis Server and everything is on the same computer..
If, i try manually connecting to Analysis Server thru Excel both via DSN and http connections it works fine..
Only problem is when I try to export the report from the web page..it gives me the connection error.
I appreciate if anyone can help me out..Thanks in advance..
Dilip
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse....cea8656828bfd2
***************************************** |