We help IT Professionals succeed at work.
Get Started

Size Limit Exceeded Error

JordansGhost
JordansGhost asked
on
2,472 Views
Last Modified: 2007-12-19
I am using ADO to return records from AD when I reach 2500 records in the recordset I get the error

Provider error '80072023'

The size limit for this request was exceeded.

/adsitest/sendwarnings.asp, line 59


Line 59 is the "WEND" part of the following statement.

WHILE NOT adoRecordSet.EOF
                  IF adoRecordSet.Fields(0).Type = 12 THEN
                  For Each sLine In adoRecordSet.Fields(0).Value
                  email = email & sLine
                  Next
                  ELSE
                  email = adoRecordSet.Fields(0).Value
                  END IF
                  IF adoRecordSet.Fields(1).Type = 12 THEN
                  For Each sLine In adoRecordSet.Fields(1).Value
                  lanid = lanid & sLine
                  Next
                  ELSE
                  lanid = adoRecordSet.Fields(1).Value
                  END IF
                  
                  Response.Write (i & ") Email = " & email & " - LANID = " & lanid & "<BR>")
                  i = i + 1
                        'SQLTest = "SELECT * FROM GALCTDTIDYwarnings WHERE smtp = '" & email & "' AND lanid = '" & lanid & "'"
                        'SET RS = cckbconn.Execute(SQLTest)
                        '
                        'IF NOT RS.EOF THEN
                              ' Already listed this user, ignore them
                        'ELSE
                        'cckbconn.Execute ("INSERT INTO GALCTDTIDYwarnings (smtp,lanid,warning) VALUES ('" & email & "','" & lanid & "',0)")
                        'END IF
                        
                        'RS.Close
                        'SET RS = Nothing
                  adoRecordSet.MoveNext
                  WEND
Comment
Watch Question
CERTIFIED EXPERT
Top Expert 2005
Commented:
This problem has been solved!
Unlock 2 Answers and 8 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE