记录集仅返回 1000 条记录

发布于 2024-07-25 20:53:56 字数 754 浏览 9 评论 0原文

我正在使用 LDAP 查询执行 ADODB recordset.open() 命令，以从 Active Directory 获取所有用户。

大约有 2600 个用户，但我只返回了其中的 1000 个。

我尝试更改记录集的 PageSize 和 MaxRecords 属性，但没有成功。

如果没有无关的东西，代码就是这样的（我已经将连接详细信息设为通用）：

ADODB.Connection conn = new ADODB.Connection();
ADODB.Recordset rs = new ADODB.Recordset();
rs.MaxRecords = 10000;
rs.PageSize = 10000;
conn.Open("Active Directory Provider","","",0);
string query = "SELECT cn FROM 'LDAP://OU=User Accounts,OU=TopLevel,DC=domainName,DC=local' where samAccountName = '*'"

rs.Open(query, conn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);

它肯定只返回 1000 条记录（我已经确认），并且我可以很好地访问它们。

如果它有帮助的话，我不使用 DirectorySearcher 的原因是因为与此相比它太慢。

原文

I'm doing an ADODB recordset.open() command with an LDAP query to get all the users from my Active Directory.

There are about 2600 users, but I'm only getting back 1000 of them.

I've tried altering the recordset's PageSize and MaxRecords properties with no luck.

Without extraneous stuff, this is what the code looks like (I've made the connection details generic):

ADODB.Connection conn = new ADODB.Connection();
ADODB.Recordset rs = new ADODB.Recordset();
rs.MaxRecords = 10000;
rs.PageSize = 10000;
conn.Open("Active Directory Provider","","",0);
string query = "SELECT cn FROM 'LDAP://OU=User Accounts,OU=TopLevel,DC=domainName,DC=local' where samAccountName = '*'"

rs.Open(query, conn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic, -1);

It's definitely only returning 1000 records, (I've confirmed), and I can access them just fine.

In case it helps, the reason I'm not using DirectorySearcher is because it's so slow in comparison to this.

分享到QQ

分享到微博