Bob Barrows -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => <#m1GZ2LpEHA.3172@TK2MSFTNGP10.phx.gbl> <#P67pSYpEHA.1308@TK2MSFTNGP14.phx.gbl> [htmlstate] => on_nl2br [postusername] => Bob [ip] => reb01501@NOyaho [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 8 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> "Bob Barrows [MVP]" wrote in message news:phx.gbl...[ref] > > Tim Kelley wrote:[ref] > > Will this work while executing server side script? > > > >[/ref] > Here's a quick example: > > <%@ Language=VBScript %> > <%Response.Buffer=true%> > > >
>
>
> > <% > 'Here is where the long-running script starts > dim t,diff > Response.Flush > t=now > do until diff > 1 > diff = DateDiff("s",t,now) > loop > 'Response.Flush > %> > > > > > > > Bob Barrows > -- > Microsoft MVP -- ASP/ASP.NET > Please reply to the newsgroup. The email account listed in my From > header is my spam trap, so I don't check it very often. You will get a > quicker response by posting to the newsgroup. > >[/ref] [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <#HJkxInpEHA.3592@TK2MSFTNGP09.phx.gbl> [ref] => <#m1GZ2LpEHA.3172@TK2MSFTNGP10.phx.gbl> <#P67pSYpEHA.1308@TK2MSFTNGP14.phx.gbl> [htmlstate] => on_nl2br [postusername] => Mark [ip] => mschupp@ielearn [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 10 [islastshown] => 1 [isfirstshown] => [attachments] => [allattachments] => ) --> Process not completing - ASP Database

Process not completing - ASP Database

I have an ASP app that creates a text file from data in a SQL 2000 database (both SQL and IIS are on Windows 2003 servers, but not on the same server). This process works fine on some clients (IE 5 or IE 6 sp1), but some of our other clients (same versions of IE that work at other client sites) never get the page that is displayed when the process is complete (even though the text file is created). Is there some timeout setting in IE that might need to be increased? The only other reason I can come ...

  1. #1

    Default Process not completing

    I have an ASP app that creates a text file from data in a SQL 2000 database
    (both SQL and IIS are on Windows 2003 servers, but not on the same server).
    This process works fine on some clients (IE 5 or IE 6 sp1), but some of our
    other clients (same versions of IE that work at other client sites) never
    get the page that is displayed when the process is complete (even though the
    text file is created). Is there some timeout setting in IE that might need
    to be increased? The only other reason I can come up with is that their is
    some ISP issue since the program works at some locations but not at others.

    Any ideas would be appreciated.

    Thanks

    Tim


    Tim Guest

  2. #2

    Default Re: Process not completing

    How long does the processing take?

    --
    Mark Schupp
    Head of Development
    Integrity eLearning
    www.ielearning.com


    "Tim Kelley" <com> wrote in message
    news:%phx.gbl... 
    database 
    server). 
    our 
    the 
    need 
    is 
    others. 


    Mark Guest

  3. #3

    Default Re: Process not completing

    The processing can take up to 45 minutes.


    "Mark Schupp" <com> wrote in message
    news:phx.gbl... 
    > database 
    > server). 
    > our [/ref]
    never 
    > the 
    > need 
    > is 
    > others. 
    >
    >[/ref]


    Tim Guest

  4. #4

    Default Re: Process not completing

    > The processing can take up to 45 minutes.

    Ouch!

    Is there any way you could launch the processing and
    then send an email when it is completed?

    Other than that you need to send something to the browser periodically so
    that it doesn't time out.

    --
    Mark Schupp
    Head of Development
    Integrity eLearning
    www.ielearning.com


    "Tim Kelley" <com> wrote in message
    news:phx.gbl... 
    > > database 
    > > server). [/ref][/ref]
    of [/ref]
    > never [/ref][/ref]
    though 
    > > need [/ref][/ref]
    their 
    > > others. 
    > >
    > >[/ref]
    >
    >[/ref]


    Mark Guest

  5. #5

    Default Re: Process not completing

    How can I send something to the browser. In my processing I could send
    something every nth record processed, but I am not sure how to send
    something to the browser. When this page is called, all of the processing
    takes place before the page is actually displayed. Would I have to send
    something to the previous page that is displayed?

    Thanks


    "Mark Schupp" <com> wrote in message
    news:%phx.gbl... 
    >
    > Ouch!
    >
    > Is there any way you could launch the processing and
    > then send an email when it is completed?
    >
    > Other than that you need to send something to the browser periodically so
    > that it doesn't time out.
    >
    > --
    > Mark Schupp
    > Head of Development
    > Integrity eLearning
    > www.ielearning.com
    >
    >
    > "Tim Kelley" <com> wrote in message
    > news:phx.gbl... [/ref]
    > of 
    > > never [/ref]
    > though [/ref][/ref]
    might [/ref]
    > their 
    > >
    > >[/ref]
    >
    >[/ref]


    Tim Guest

  6. #6

    Default Re: Process not completing

    Response.buffer = true

    while not done

    do some processing

    response.write "working...<br>"
    Response.Flush

    loop

    What some people do is output a script block to update an HTML element (DIV,
    SPAN, etc) so that they do not have a scrolling display. I believe their are
    some examples in www.aspfaq.com or on the other ASP information sites.
    Typical description of the technique is "showing progress".


    --
    Mark Schupp
    Head of Development
    Integrity eLearning
    www.ielearning.com


    "Tim Kelley" <com> wrote in message
    news:O5w63$phx.gbl... 
    > >
    > > Ouch!
    > >
    > > Is there any way you could launch the processing and
    > > then send an email when it is completed?
    > >
    > > Other than that you need to send something to the browser periodically[/ref][/ref]
    so [/ref][/ref]
    some [/ref][/ref]
    sites) 
    > > though [/ref]
    > might 
    > > their [/ref][/ref]
    at 
    > >
    > >[/ref]
    >
    >[/ref]


    Mark Guest

  7. #7

    Default Re: Process not completing

    Will this work while executing server side script?


    "Mark Schupp" <com> wrote in message
    news:O4z3$phx.gbl... 
    (DIV, 
    are [/ref]
    processing [/ref]
    > so [/ref][/ref]
    2000 [/ref][/ref]
    same [/ref]
    > some [/ref]
    > sites) [/ref][/ref]
    (even 
    > > might [/ref][/ref]
    that [/ref]
    > at 
    > >
    > >[/ref]
    >
    >[/ref]


    Tim Guest

  8. #8

    Default Re: Process not completing


    Tim Kelley wrote: 
    Here's a quick example:

    <% Language=VBScript %>
    <%Response.Buffer=true%>
    <HTML><BODY>
    <style type="text/css">
    ..pBar {
    border: thin inset black;
    background-color:navajowhite;
    padding-left:5px;
    padding-right:5px
    }
    div.1 {
    border-top:5px solid navajowhite;
    border-bottom:5px solid navajowhite;
    text-align: left;
    background-color: navajowhite;
    width: 100%;
    height: 10px;
    }
    div.2 {
    border-top:5px solid navajowhite;
    border-bottom:5px solid navajowhite;
    text-align: right;
    background-color: blue;
    color:white;
    height: 10px;
    }
    </style>
    <span id=spTime></span><BR>
    <div id=progressBar class=pBar>
    <div id="hr1" class=1></div></div>
    <script type="text/jscript">
    var timeID
    function doit() {
    var nPercent = Number('1');
    var curwidth=Number(hr1.style.width.replace("%",""));
    hr1.className="2";
    var newWidth=curwidth + Number(nPercent);
    if (newWidth % 10 == 0)
    {
    spTime.innerText=newWidth
    }
    if (newWidth > 100){
    newWidth = 0
    }
    hr1.style.width= newWidth + "%";
    timeID = setTimeout("doit()",10);
    }
    //spTime.innerText="0.1"
    setTimeout("doit()",100);
    </script>
    <%
    'Here is where the long-running script starts
    dim t,diff
    Response.Flush
    t=now
    do until diff > 1
    diff = DateDiff("s",t,now)
    loop
    'Response.Flush
    %>

    <!--the rest of the page follows here-->
    </BODY>
    <script type="text/jscript">
    clearTimeout(timeID);
    progressBar.style.display="none";
    spTime.innerText="Finished";
    </script>
    </HTML>

    Bob Barrows
    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Guest

  9. #9

    Default Re: Process not completing

    Tim Kelley wrote: 
    I strongly suggest using another technique for accomplishing this task. A 45
    min. process should not be done by an ASP page. Such a process could be
    _initiated_ by the page, but the page should not wait around for that
    process to complete. This is a misuse of web server resources.

    Bob Barrows

    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Guest

  10. #10

    Default Re: Process not completing

    I would do something more like this (where asp process controls the bar).
    Your suggestion that the processing be done outside of ASP is a better
    solution but he didn't seem inclined to go that way when I suggested it.

    --
    Mark Schupp
    Head of Development
    Integrity eLearning
    www.ielearning.com

    <% Language=VBScript %>
    <%Response.Buffer=true%>
    <HTML><BODY>
    <style type="text/css">
    ..pBar {
    border: thin inset black;
    background-color:navajowhite;
    padding-left:5px;
    padding-right:5px
    }
    div.1 {
    border-top:5px solid navajowhite;
    border-bottom:5px solid navajowhite;
    text-align: left;
    background-color: navajowhite;
    width: 100%;
    height: 10px;
    }
    div.2 {
    border-top:5px solid navajowhite;
    border-bottom:5px solid navajowhite;
    text-align: right;
    background-color: blue;
    color:white;
    height: 10px;
    }
    </style>
    <span id=spTime></span><BR>
    <div id=progressBar class=pBar>
    <div id="hr1" class=1></div></div>
    <script type="text/jscript">

    function setbar( nPct )
    {
    hr1.className="2";
    spTime.innerText=nPct + "%";
    hr1.style.width= nPct + "%";
    }
    setbar(0);
    </script>
    <%

    Response.Flush

    'Here is where the long-running script starts
    dim i

    for i = 1 to 1000000 'simulate long running script

    'update percent complete periodically.
    if i/10000 = CLng(i/10000) then
    'Response.Write CStr(Clng(i/10000)) & "-"
    Response.Write "<script language=""javascript"">setbar(" &
    CStr(CLng(i/10000)) & ");</script>"
    Response.Flush
    End if

    next

    %>

    <!--the rest of the page follows here-->
    </BODY>
    <script type="text/jscript">
    progressBar.style.display="none";
    spTime.innerText="Finished";
    </script>
    </HTML>


    "Bob Barrows [MVP]" <SPAMcom> wrote in message
    news:phx.gbl... 
    > Here's a quick example:
    >
    > <% Language=VBScript %>
    > <%Response.Buffer=true%>
    > <HTML><BODY>
    > <style type="text/css">
    > .pBar {
    > border: thin inset black;
    > background-color:navajowhite;
    > padding-left:5px;
    > padding-right:5px
    > }
    > div.1 {
    > border-top:5px solid navajowhite;
    > border-bottom:5px solid navajowhite;
    > text-align: left;
    > background-color: navajowhite;
    > width: 100%;
    > height: 10px;
    > }
    > div.2 {
    > border-top:5px solid navajowhite;
    > border-bottom:5px solid navajowhite;
    > text-align: right;
    > background-color: blue;
    > color:white;
    > height: 10px;
    > }
    > </style>
    > <span id=spTime></span><BR>
    > <div id=progressBar class=pBar>
    > <div id="hr1" class=1></div></div>
    > <script type="text/jscript">
    > var timeID
    > function doit() {
    > var nPercent = Number('1');
    > var curwidth=Number(hr1.style.width.replace("%",""));
    > hr1.className="2";
    > var newWidth=curwidth + Number(nPercent);
    > if (newWidth % 10 == 0)
    > {
    > spTime.innerText=newWidth
    > }
    > if (newWidth > 100){
    > newWidth = 0
    > }
    > hr1.style.width= newWidth + "%";
    > timeID = setTimeout("doit()",10);
    > }
    > //spTime.innerText="0.1"
    > setTimeout("doit()",100);
    > </script>
    > <%
    > 'Here is where the long-running script starts
    > dim t,diff
    > Response.Flush
    > t=now
    > do until diff > 1
    > diff = DateDiff("s",t,now)
    > loop
    > 'Response.Flush
    > %>
    >
    > <!--the rest of the page follows here-->
    > </BODY>
    > <script type="text/jscript">
    > clearTimeout(timeID);
    > progressBar.style.display="none";
    > spTime.innerText="Finished";
    > </script>
    > </HTML>
    >
    > Bob Barrows
    > --
    > Microsoft MVP -- ASP/ASP.NET
    > Please reply to the newsgroup. The email account listed in my From
    > header is my spam trap, so I don't check it very often. You will get a
    > quicker response by posting to the newsgroup.
    >
    >[/ref]


    Mark Guest

Similar Threads

  1. InDesign quits before completing packaging files
    By Bob_Thompson22@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 1
    Last Post: September 21st, 08:25 PM
  2. Adobe PDF Printer getting exlimation pointand not completing print
    By Brian_Yanosik@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 9
    Last Post: May 25th, 09:59 PM
  3. Completing a button movie
    By DGClarke in forum Macromedia Flash Sitedesign
    Replies: 11
    Last Post: February 20th, 02:29 PM
  4. Earn money by completing serveys, not points!!!
    By paul in forum PHP Development
    Replies: 3
    Last Post: December 30th, 09:12 AM
  5. Completing Forms Authentication failure
    By Arne Håveland in forum ASP.NET Security
    Replies: 1
    Last Post: November 26th, 04:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •