1000 rows limit when performing heterogenous join between SQL and ADAM

  • Thread starter Thread starter CY
  • Start date Start date
C

CY

Hi,
I have configured a remote link between SQL and ADAM. I created 2000 users
in ADAM and have no problem using directory services programming or other
LDAP tools to list all 2000 users. However, when I used OPENQUERY to
retrieve ADAM users via the remote SQL link, it only returned the first 1000
ADAM users. From what I read in msdn, it could be due to paging in ADSI
searches (ADSI search preference is set to no paging). Hope I am right...
so how do I configure the ADSI provider in SQL to do paging?

Thanks.
 
In vbscript/ADSI it would be:

objCommand.Properties _
("Page Size")= Records

where Records is the number of records the domain controller should
return before continuing the search.

and

objCommand.Properties _
("Size Limit")= Records

where Records is the number of records the domain controller should
return before completing the search.

The default size limit of a search is 1,000 records.


Chris Malone
Microsoft Directory Services
 
You really really don't want to change MaxPageSize. You expose the DC to
Denial of Service attacks that way.

The proper way is to leave the page size alone and just do paged searches.
All of the MS APIs for searching AD allow you to do that. Normally you just
set PageSize=1000 (or whatever number you want <= the max page size).

Joe K.
 
Back
Top