Migrating app from IIS5 to IIS6 problem

Hi

I have a simple DB app using an Access databse that I have had to
migrate from an IIS 5 box to IIS 6. The app basically asks users to
fill in a search form which then returns relevant records. If the
result returns more than about 500 records then the page fails to load
(page cannot be displayed error). With fewer records then it works
fine. It all worked fine on the IIS 5 box.

Now if I remove 4 of the displayed fields by just deleting the field
from the code below (i.e. deleting every thing between the <tr> </tr>
tags so that there are fewer fields to display for each record then it
works again. Looks like it's complaining about the amount of data
returned but it's only a few hundred records.

Can anyone shed any light?

The code that displays the records:

..
..
..
'create a recordset
set sqlResults = server.createobject("ADODB.recordset")
sqlResults.open selectPart, dBconnection, 1, 3
CountRecords = sqlResults.recordcount

%>

<font color="navy" face="arial">&nbsp;
<P></P>
<center>

<table align="center" border="2" width="589" bordercolor="navy"
bgcolor="#e6e6e6">
<TR>
<TD width="571" height="26" valign="top" align="middle"> <font
color="navy" size=+1><B><%=CountRecords%>
record(s) held</B></font> </TD>
</TR>
</table>

<%do while not sqlResults.EOF%>

<table align="center" border="2" width="589" height ="95%"
bordercolor="navy" bgcolor="lightblue" style="HEIGHT: 103px; WIDTH:
589px">
<TR>
<TD align="right" valign="top" width ="199"
bgcolor="lightblue"><font color="navy"><B>
Part No:&nbsp;</B></font></TD>
<TD align="middle" width= "372" bgcolor="#e6e6e6"><font color
="navy"><B><%=sqlResults(" Part No")%>
</B></font></TD>
</TR>
<TR>
<TD align="right" valign="top" bgcolor="lightblue"><font
color="navy"><B>Manufacturers
Part No:</B></font></TD>
<TD align="middle" bgcolor="#e6e6e6"><font color
="navy"><B><%=sqlResults("Manuf Part No")%>
</B></font></TD>
</TR>
..
..
About 10 more fields listed here in the same way as the above ones.
..
..
<%

sqlResults.MoveNext
loop

%>
</TABLE>

.

Relevant Pages

  • Re: Default Web Page
    ... > default web page to display when I attempt to access the server from the ... If I access from the internet side according to the ... it should display the 'Under Construction' page. ... Security settings of IIS prevent viewing this page over the net I think. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Adding a remote printer
    ... No, I can't get a display, except for the IE error page, when trying to ... IIS is running, I even put a default web page up, but even though the web ... HP LaserJet 5/5M PostScript Ready 0 HP LaserJet 5/5M PostScript ... How do I configure, from my house, the printer at my friend's house, who ...
    (microsoft.public.windowsxp.print_fax)
  • Re: Intercept a request before SharePoint handles it.
    ... >I have an Asp.net page that I want to display for the entry point to ... > -- Show a usage warning, let them accept the terms which takes them to ... > the "real" entry point of the site. ... > -- Removed the default page from IIS and made my warning page the ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Problem displaying JPEG files through localhost
    ... Kristofer Gafvert - IIS MVP ... > through localhost on my workstation, JPEG-files do not display - a red ... > in IE and nothing in Mozilla; trying to browse the images from the folder ... > images, while GIF's and PNG's are displayed regardless of browser, so the ...
    (microsoft.public.inetserver.iis)
  • Re: error codes
    ... IIS Status code, refer ... You can have the IP display in the event viewer ... I am seeing this and others in> the logs for my web server. ... how do i get event> viewer security to display the ip of someone trying> multiple passwords to get in? ...
    (microsoft.public.inetserver.iis.security)