dbTalk Databases Forums  

Export to Excel option in Pivot Table list giving connection errors.

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Export to Excel option in Pivot Table list giving connection errors. in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dilip Nair via SQLMonster.com
 
Posts: n/a

Default 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
*****************************************

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.