dbTalk Databases Forums  

ADOMD & COM Interop

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


Discuss ADOMD & COM Interop in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jdwakefield@gmail.com
 
Posts: n/a

Default ADOMD & COM Interop - 11-09-2006 , 02:43 AM






Hi,

This has been bugging me all week and I really need some help or
pointing in the right direction.

I have setup some aspx vb.net pages with Visual Web Developer and the
ReportViewer Control.
I basically issue an MDX statement through ADOMD, populate a dataset
and display the results in the ReportViewer.

This all works great on my laptop (Windows XP, IIS 5.1) but when I
transfer it to my live server (Win2003, IIS 6.0) it will work fine for
a while and then any page that issues ADOMD commands will suddenly
stops working and basically time out.

The only way to get the reports working again is to restart IIS or
recycle the DefaultApp. I sometimes get error messages in the Event
Viewer relating to DCOM and asp 2.0 but nothing that really coincides
with the report stopping.

I can only guess that IIS 6.0 has some issue with the COM+ interop. I
have tried making all sorts of setting changes to IIS without success.

Any help would be much appreciated.

Thanks

wakey


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.