Re: Handling Script Timeout when invoking ActiveX Object

From: Patrick (patl_at_reply.newsgroup.msn.com)
Date: 11/11/04 

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
> >
>
>

Relevant Pages

  • Re: Handling Script Timeout when invoking ActiveX Object
    ... In a proper scenario, I have an ASP Page, which ... err.Description= New transaction cannot enlist in the specified transaction ... With this production ASP page, ... how could I prevent this standard Microsoft error from being ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Handling Script Timeout when invoking ActiveX Object involving ADODB from ASP2.0 pages
    ... With the ASP file listed at the end of this post, ... I load the ASP on Server A, ... New transaction cannot enlist in the specified transaction coordinator. ... Const adOpenKeyset = 1 ...
    (microsoft.public.inetserver.asp.general)
  • Re: Handling Script Timeout when invoking ActiveX Object
    ... It seems to be the ADODB that is causing the problem! ... > err.Description= New transaction cannot enlist in the specified ... how could I prevent this standard Microsoft error from being ... >> The maximum amount of time for a script to execute was exceeded. ...
    (microsoft.public.inetserver.asp.general)
  • Re: xp_sendmail in trigger from asp page -error
    ... You may get more help in an ASP ... newsgroup but please include the exact error message you have. ... open a transaction while you do this and it is bad practice to do so simply ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: DTC fails when number of updates in huge
    ... Do you use an other components with the ASP? ... after the transaction is committed. ... >> these updates performed as one big transaction or as individual ... >> Sam Santiago ...
    (microsoft.public.dotnet.distributed_apps)