Illustrious Group,

I think I've figured out the solution to my ACTUAL problem by utilizing a
initial Server.CreateObject connection, populating an array and then
utilizing that data in the array in a second (un-nested) Server.CreateObject
connection.  However, I'd still like to know what's actually causing the
error on my initial approach (just for knowledge's sake).

- Conrad Shull

> -----Original Message-----
> From: Shull, Conrad 
> Sent: Tuesday, September 26, 2000 11:03 AM
> To: 'hwg-languages(at)hwg.org'
> Subject: Nested Server.CreateObject & too many client tasks?
> 
> 
> 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