Re: VB Scripting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tomasz Onyszko (T.Onyszko_at_w2k.pl)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 20:51:28 +0200

Mat wrote:
> I'm connecting to our AD database using the following statements in a VB
> Script to pull out the user name and phone number:
>
> Set objConnection = CreateObject("ADODB.Connection")
> objConnection.Open "Provider=ADsDSOObject;"
> Set objCommand = CreateObject("ADODB.Command")
> objCommand.ActiveConnection = objConnection
>
>
> objCommand.Properties("Sort On") = "Name"
> objCommand.CommandText = "<LDAP://MY_DOMAIN>;(objectCategory=user)" &
> ";ADsPath,Name,telephoneNumber;subtree"
>
> Set objRecordSet = objCommand.Execute
>
> It all appears to work ok, but when I check the logs from the script it
> appears to only be searching through the first 1000 users in the database.
> Can anyone tell me if there's a limit to how many users you can search
> through using the above command? Or, does anyone have any other ideas on
> what's happening?
>
> Any help is appreciated

You have to turn on results paging for your results - this can be doen
by specyfing a number on records in one page:

objCommand.Properties("Page Size") = 1000 

-- 
Tomasz Onyszko [MVP]
T.Onyszko@w2k.pl
http://www.w2k.pl

Relevant Pages

  • Is there a better way > Auto Enter Serial Number in FMPro 9?
    ... I've been searching for a couple days now for the solution to ... resetting the "Record Number" in my database. ... I was able to locate this simple looking enough script from the web: ...
    (comp.databases.filemaker)
  • VB Scripting
    ... I'm connecting to our AD database using the following statements in a VB ... Set objConnection = CreateObject ... It all appears to work ok, but when I check the logs from the script it ... appears to only be searching through the first 1000 users in the database. ...
    (microsoft.public.win2000.active_directory)
  • Save As box question
    ... My users can pull up some information from the database and view it. ... the script should format the data into a CSV format ...
    (comp.lang.php)
  • Re: Query for Database, Table, Index name all on one list.
    ... I want to create a script that will pull all the database names, ... Prev by Date: ...
    (microsoft.public.sqlserver)
  • Re: Get custom database properties from an Access database
    ... It doesn't matter if the VBScript process drags, since it is an independent process and so will have no effect on the user's interaction with the database. ... The user can skip merrily along, doing whatever he needs while the script invisibly figures out the current situation in the background and decides what to do about it. ... It does, but I've run into issues other places on this same network, where users needed a drive letter to a server. ...
    (microsoft.public.scripting.vbscript)