Hi There,

I'm running an ASP site that talks to a COM+ app server and also a COM+ data server.

I recently changed some data server components to start using ADO paging to handle smaller recordsets. All is ok but when the ADOR recordset is returned to my ASP the pagesize always returns 10!?!?!? This of course messes up the total page count as it has calculated on 10 records per page. I.e setting a page count & cache size of 25 still gives me pagecount and size of 10 in the ASP GUI.

Debugging the VB COM+ components I see that the page counts are all ok!

The data layer and business layer both return and ADOR recordset. The data layer is using a client side cursor,forward only and read only.

I have tried setting the pagesize in the ASP before and after recordset is returned from the COM+ component to no avail!!

AAAAAAAAAAAAAAGH!

oh dear....

Setting the pagesize after the COM+ component returns the recordset seems to work ok!

How cr@p is that? You'd think the data layers page sizes would take presidence?????