I have a nested VBScript ASP routine (VERY simplified version below) that
returns a "Too many client tasks" error after about the 60th "conn" record
(There are about 250 in the TblAttendees table).  I'm using an Access
database (wish I was using SQL Server, but I'm not.)  I'd love some
enlightenment on what's wrong.

Thanks, Conrad Shull

<% 
'---- Primary Connection, Query & Results ----------

Set conn = Server.CreateObject("ADODB.Recordset")
SqlTemp = "SELECT FirstName, LastName, AttendeeID FROM TblAttendees"
conn.Open SqlTemp, "DSN=cms2000;"
While Not conn.EOF

FirstName = conn("FirstName")
LastName = conn("LastName")
AttendeeID = conn("AttendeeID")

'---- Sub Connection, Query & Results ----------

Set rs = Server.CreateObject("ADODB.Recordset")
SqlTemp2 = "SELECT EMail FROM TblAddresses WHERE AttendeeID = " & AttendeeID
rs.Open SqlTemp2, "DSN=cms2000;"
While Not rs.EOF

EMail = rs("EMail")

rs.MoveNext
wend
rs.close
set rs = nothing

'---- End Sub Connection, Query & Results ----------

	Response.Write LastName & ", " & FirstName & ", " & EMail & "<br>"

conn.MoveNext
wend
conn.close
set conn = nothing
%>

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA