Browser hangs with ASP

[Kevin Shea]

In my web application, client browsers (IE6) get data by creating ADO
recordsets that open up ASP pages on the server. The server queries a SQL
Server database and returns data to the client by persiting it in XML format
in a Response object.

This works fine in most cases, but for larger data sets (e.g.: 3200 records
of 10 fields) I see behavior where the client browser hangs, and I have to
kill it and restart the browser. However, I don't have to do anything else
to the server, I can just open up a new browser on the client and connect
again.

Any ideas? Any suggestions for debugging this issue?

Thanks in advance,

Kevin

[Mike Collier]

> This works fine in most cases, but for larger data sets (e.g.: 3200
records

> of 10 fields) I see behavior where the client browser hangs,

command timeout
[url]http://81.130.213.94/myforum/forum_posts.asp?TID=69&PN=1[/url]

--
Mike Collier
FREE ADO Inspector tool when you register at ADO forum.
[url]www.adoanywhere.com[/url]
[url]http://www.adoanywhere.com/forum[/url]

[Kevin Shea]

Mike,

Thanks for your response, I have an additional question.

Is there a CommandTimeout property for opening up a recordset using an ASP
page.

For example, in my code, I'm doing the following on the client:

var rst = new ActiveXObject("ADODB.Recordset");
rst.CursorLocation = 3;//adUseClient
rst.CursorType = 0;//default,adOpenForwardOnly
rst.LockType = 1;//adLockReadOnly
rst.Open(funcURL);

Here, I don't have a command object or a connection object.

On the server, I do the following:

rs.Save(Response, adPersistXML);

Thanks,

Kevin
"Mike Collier" <noemail@noemail> wrote in message
news:ed2pxW25DHA.3304@tk2msftngp13.phx.gbl...

> > This works fine in most cases, but for larger data sets (e.g.: 3200

> records

> > of 10 fields) I see behavior where the client browser hangs,

>
> command timeout
> [url]http://81.130.213.94/myforum/forum_posts.asp?TID=69&PN=1[/url]
>
> --
> Mike Collier
> FREE ADO Inspector tool when you register at ADO forum.
> [url]www.adoanywhere.com[/url]
> [url]http://www.adoanywhere.com/forum[/url]
>
>

[Mike Collier]

Hi Kevin,

> Is there a CommandTimeout property for opening up a recordset

As far as I know this can't be done with just a recordset. You will need to
use an object that supports CommandTimeout to get your recordset.

--
Mike Collier
FREE ADO Inspector tool when you register at ADO forum.
[url]www.adoanywhere.com[/url]
[url]http://www.adoanywhere.com/forum[/url]




"Kevin Shea" <kshea@mathworks.com> wrote in message
news:O2ivH$Z6DHA.2264@tk2msftngp13.phx.gbl...

> Mike,
>
> Thanks for your response, I have an additional question.
>
> Is there a CommandTimeout property for opening up a recordset using an ASP
> page.
>
> For example, in my code, I'm doing the following on the client:
>
> var rst = new ActiveXObject("ADODB.Recordset");
> rst.CursorLocation = 3;//adUseClient
> rst.CursorType = 0;//default,adOpenForwardOnly
> rst.LockType = 1;//adLockReadOnly
> rst.Open(funcURL);
>
> Here, I don't have a command object or a connection object.
>
> On the server, I do the following:
>
> rs.Save(Response, adPersistXML);
>
> Thanks,
>
> Kevin
> "Mike Collier" <noemail@noemail> wrote in message
> news:ed2pxW25DHA.3304@tk2msftngp13.phx.gbl...

> > > This works fine in most cases, but for larger data sets (e.g.: 3200

> > records

> > > of 10 fields) I see behavior where the client browser hangs,

> >
> > command timeout
> > [url]http://81.130.213.94/myforum/forum_posts.asp?TID=69&PN=1[/url]
> >
> > --
> > Mike Collier
> > FREE ADO Inspector tool when you register at ADO forum.
> > [url]www.adoanywhere.com[/url]
> > [url]http://www.adoanywhere.com/forum[/url]
> >
> >

>
>