dbTalk Databases Forums  

ADOConPool with ASP.NET/C#... not working!

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


Discuss ADOConPool with ASP.NET/C#... not working! in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Will Muldrew
 
Posts: n/a

Default ADOConPool with ASP.NET/C#... not working! - 05-04-2004 , 01:46 PM






Hi all... please help...

I'm trying to use an ADOConPool with my ASP.NET app written in C#. If I put
this test code:

MSXmlAnalysisSCLib.ADOConPool p = new MSXmlAnalysisSCLib.ADOConPoolClass();
ADODB.Connection c =
(ADODB.Connection) p.GetConnection("Provider=MSOLAP.2;Data
Source=riskln2;Initial Catalog=RiskDW;");

into the Main routine of a console app it runs with no problems. If I put
the same code in the Page_Load method of a one webform toy web app it throws
an SEHException with the generic message "External component has thrown an
exception. " when it hits the GetConnection line. The connection strings
are identical and it's running on the same machine.

I've set the AspTrackThreadingModel setting to true for the webapp as per
the MS whitepaper, but I don't think it matters since I've not (in this
example) storing the pool object in session or app state.

Also, the app is set to impersonate the client user as authenticated by
integrated authentication. I know this is working because I can explicitly
open an ADO DB connection myself in the Page_Load method and run some mdx
against it using the ADO MD API.

Has anyone got any ideas - or at least some way in which I can get more
expansive error information from the connection pool object??

Thanks

Will Muldrew



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.