dbTalk Databases Forums  

Running ADOMD .NET in a separate thread

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


Discuss Running ADOMD .NET in a separate thread in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris Herring
 
Posts: n/a

Default Running ADOMD .NET in a separate thread - 12-05-2005 , 05:42 PM






We have a VB .NET application that connects to a SQL Server Analysis
Services (2000) server.
We want to provide our users with the opportunity to cancel execution during
long queries so in order to be responsive to the users actions we have tried
executing the query from another thread.
This runs fine but seems to mess up the AdomdConnection object i.e. once the
spawned thread has finished executing and control is returned to the main
thread, then although the State property of the AdomdConnection object
returns Open, referencing other properties may raise a
InvalidOperationExeception or InvalidCastExeception.
The only way I have found to ensure the integrity of the AdomdConnection
object after execution is to close and reopen the connection which can take
some time.

Any ideas?

Chris



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.