Re: ADOConPool not working with c#/ASP.NET

From: Akshai Mirchandani [MS] (akshaim_at_online.microsoft.com)
Date: 05/05/04 

Date: Wed, 5 May 2004 10:42:57 -0700

Is there anything in the inner exception? We'll try to reproduce this
problem here...

Thanks,
Akshai 

--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Will Muldrew" <nospamplease@nospam.com> wrote in message
news:ucOyyegMEHA.936@TK2MSFTNGP11.phx.gbl...
> 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
>
>

Relevant Pages

  • Long delay when using ADO and CRichEditCtrl in W98
    ... Recently when using ADO (Opening a cconnection, reading records, deleting them and closing the connectio in a .mdb file ... DestroyWindow on a CRichEditCtrl I have got a delay of about 10 seconds where my app seems to be frozen. ... If I don't open and close the ADO connection no delay is noticed. ...
    (microsoft.public.vc.mfc)
  • Re: BDE to ADO
    ... > I am somewhat confused regarding defining ADO connections. ... With BDE I do not have to code server and database ... > information in the app. ... If you want to store the connection info outside of the app, ...
    (borland.public.delphi.database.ado)
  • Problem upgrading project in VS2008 - _ConnectionPtr::Open on DQL Server now v. slow.
    ... It uses ADO to connect to a sql server 2005 database. ... When compiled under VS2008, the first time in my app takes around 30 seconds to return from _ConnectionPtr::Open, though if I close the connection and then open it again it's back to near instant. ... I've created a simple console app with the bare minimum stuff needed for ADO with MFC and it connects instantly under VS2008. ...
    (microsoft.public.vc.mfc)
  • ADO problem on XP, Provider cannot be found
    ... ADO connection, it fails with the message 'Provider cannot be found. ... The error message occurs in our compiled VB app, but I've tried a small test ...
    (microsoft.public.data.ado)
  • Re: A month with a Nokia n95 (long)
    ... and can't play. ... One of these days I will get around to writing a small app to do it all on the fly. ... HSDPA works well and you can have more than one internet connection going at once. ... For example I can use it as a modem for my laptop and also "listen again" to a Beeb radio programme. ...
    (uk.telecom.mobile)