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 |