VB Scripting

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

From: Mat (Mat_at_discussions.microsoft.com)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 09:01:35 -0700

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

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)
  • Re: VB Scripting
    ... > Script to pull out the user name and phone number: ... > 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)
  • 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)
  • Re: Get custom database properties from an Access database
    ... write the script to look for an available letter, ... If you're concerned about another drive letter causing ... will have no effect on the user's interaction with the database. ... As for the server, yes, that would definitely be the way to go. ...
    (microsoft.public.scripting.vbscript)
  • Re: Get custom database properties from an Access database
    ... will write the script to look for an available letter, ... If you're concerned about another drive letter causing ... will have no effect on the user's interaction with the database. ... As for the server, yes, that would definitely be the way to go. ...
    (microsoft.public.scripting.vbscript)