Testimonial: I manage a large 800 station 1750 user Windows Server 2003 based network for a sizeable secondary school in the UK. Year on year we have to create approx 350 new user accounts from data supplied to us from our local education authority in CSV format. Creating the user accounts manually was a very tedious process which no one enjoyed and which tied up staff at one of our busiest times of the year. ... Andrew Dunlop The Mcauley Catholic High School http://www.mcauley.org.uk read more...

Script section: Connecting to the UMRA Service

The database connection is not initialized. For each record returned from the database, a user account must be created. Before the loop to create the accounts is implemented, a connection must be setup with the UMRA Service. This is done by creating the Umra COM object of UMRA COM and calling the Connect method of the object.

Dim Umra, Username, UserPassword

Set Umra = CreateObject("UmraCom.Umra")

RetVal = Umra.Connect("AMAZONE", 56814)

First, the variables are declared. The Umra variable will hold the COM object. The variables Username and UserPassword will hold the text values of the user name and password for the created user account. The values will be shown to the end user

The UMRA COM object Umra is then created with the CreateObject call. The argument UmraCom.Umra specifies the UMRA COM library and the type of object (Umra) of which an instance must be created. If the UMRA COM library is not installed and/or registered, the CreateObject call will fail.

The UMRA COM object now connects to the UMRA Service with the statement RetVal=Umra.Connect("AMAZONE",56814). The Connect method takes two arguments: the name of the computer that runs the UMRA Service and the port number used by the UMRA Service. 56814 is the default UMRA Service port number.

On success, the return value of the Connect method is zero. The UMRA COM object is now connected to the UMRA Service.