Re: Handling Script Timeout when invoking ActiveX Object
From: Patrick (patl_at_reply.newsgroup.msn.com)
Date: 11/11/04
- Next message: Mark Oueis: "Re: Reading File Summary in .NET"
- Previous message: /dev/null: "RE: COM Exception handling"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 11 Nov 2004 15:30:52 -0000
Also, I can only get the example working with the "Mickey mouse" MSDN
Example.
In a proper scenario, I have an ASP Page, which
1) server.createobject("adodb.connection") an ADODB.connection
2) invokes. execute(mySQL) on the ADODB.connection to get a Record Set
3) Does a CreateObject on a .NET Class Library via Interop (using the regasm
/tlb tool)
4) Invoke a method on the ActiveX object of 3
Problems
1) When the page is set to either of the following
<%@ TRANSACTION=REQUIRES_NEW LANGUAGE="VBScript" %>
<%@ TRANSACTION=REQUIRED LANGUAGE="VBScript" %>
2) I get error
err.number= -2147168246
err.Description= New transaction cannot enlist in the specified transaction
coordinator.
( After the page loads, resulting in the above error, the COM+ Committed
Transaction statistics increments by 1, this is on IIS5.1 on WinXP
Professional SP1)
3) The page runs without error (with the exception when the page timeout, of
course) when
3.1) The page has no transaction attributes set or
3.2) Transaction attribute is set to SUPPORTED or NOT_SUPPORTED
4) With this production ASP page, the OnTransactionAbort sub-routine is not
fired off even when the page times-out!
SOS
"Patrick" <patl@reply.newsgroup.msn.com> wrote in message
news:u2PiL29xEHA.2016@TK2MSFTNGP15.phx.gbl...
> Thanks, but this MSDN article only *partially* solve the problem!
>
> Yes, when the script timed-out in the infinite loop as in the example code
> from the article, the OnTransactionAbort EventHandler get fired to print
out
> the desired output. Unfortunately, before the output from the
EventHandler
> is displayed, the standard Microsoft error has already displayed, as
> follows, how could I prevent this standard Microsoft error from being
> displayed!!
> Active Server Pages error 'ASP 0113'
>
> Script timed out
>
> /timeout.asp
>
> The maximum amount of time for a script to execute was exceeded. You can
> change this limit by specifying a new value for the property
> Server.ScriptTimeout or by changing the value in the IIS administration
> tools.
>
>
> "[MSFT]" <lukezhan@online.microsoft.com> wrote in message
> news:gwYOFu5xEHA.3440@cpmsftngxa10.phx.gbl...
> > Hello Patrick,
> >
> > You may take a look at following article to see if it can resolve the
> > problem:
> >
> > HOWTO: Use MTS to Trap Error 'ASP 0113' Script Timed Out
> > http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q182036
> >
> > Luke
> >
>
>
- Next message: Mark Oueis: "Re: Reading File Summary in .NET"
- Previous message: /dev/null: "RE: COM Exception handling"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
