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 |