MOTOBIT.COM - ASP upload, IIS utility OperatorPrivileges usage

Article | Member of UserManager.OperatorPrivileges | Changes | Purchase | Download

1. Identities

Library name: ActiveX UserManager 1.7
Library code: UserManager
Library CLSID: E5D2CE13-5FA0-11D2-A666-204C4F4F5020
ProgID: UserManager.OperatorPrivileges
Library file name: UserMan.OCX

2. Scripting engines without types (VB Script, JavaScript, JScript, WSH, ASP)

You can create the object using CreateObject function:

Dim OperatorPrivileges
Set OperatorPrivileges = CreateObject("UserManager.OperatorPrivileges")
OperatorPrivileges.SomeMethod SomeParameters
OperatorPrivileges.SomeProperty = SomeValue

You can also use CreateObject method method of Server object (ASP) to put the OperatorPrivileges object to page scope or CreateObject method of WScript object in WSH.

You can also put the object to Application or Session scope using <object ...> tag in global.asa

<object runat="server" scope="application" id="OperatorPrivileges"
 progid="UserManager.OperatorPrivileges">
</object>

Please use ActivexObject object in JScript/JavaScript to create OperatorPrivileges object:

var OperatorPrivileges;
OperatorPrivileges = new ActiveXObject("UserManager.OperatorPrivileges");
OperatorPrivileges.SomeMethod(SomeParameters)
OperatorPrivileges.SomeProperty = SomeValue
...

3. VBA (VBA 5, VBA 6, Visual Studio, Word, Excel, MS Access, ...)

VBA 5/6: You can reference the library using menu Project -> References -> select 'ActiveX UserManager 1.7' in the listbox (or Project -> References -> Browse -> select UserMan.OCX file).
MSAccess, Word, Excel: Tools -> Macro -> Visual Basic Editor, then Tools -> References
Then you can write:

Dim OperatorPrivileges As New UserManager.OperatorPrivileges
OperatorPrivileges.SomeMethod SomeParameters
OperatorPrivileges.SomeProperty = SomeValue
    ...

Dim OperatorPrivileges As UserManager.OperatorPrivileges
...
Set OperatorPrivileges = New UserManager.OperatorPrivileges
OperatorPrivileges.SomeMethod SomeParameters
OperatorPrivileges.SomeProperty = SomeValue
...

You can use CreateObject function also, of course:

Dim OperatorPrivileges As UserManager.OperatorPrivileges
...
Set OperatorPrivileges = CreateObject("UserManager.OperatorPrivileges")
OperatorPrivileges.SomeMethod SomeParameters
OperatorPrivileges.SomeProperty = SomeValue
...

4. Visual Studio .NET (ASP.Net, VB.Net, C#, J#)

You can reference the library using menu Project -> Add reference -> COM tab -> select 'ActiveX UserManager 1.7' in the listbox -> click Select. Then you can write (C#, J#):

 //create  a new OperatorPrivileges object
 UserManager.OperatorPrivileges OperatorPrivileges = new UserManager.OperatorPrivilegesClass(); 
 OperatorPrivileges.set_String("Some text value"); 
 





 String SQL; 
 SQL = "Insert Into Table (BinaryColumn) values (0x" + OperatorPrivileges.get_HexString() + ")"; ...

or (VBA)

Dim OperatorPrivileges As New UserManager.OperatorPrivileges 
OperatorPrivileges.SomeMethod(SomeParameters)
OperatorPrivileges.SomeProperty = SomeValue

5. T-SQL, MS SQL stored procedures and functions

DECLARE @OperatorPrivileges INT, @OLEResult INT 
EXECUTE @OLEResult = sp_OACreate 'UserManager.OperatorPrivileges', @OperatorPrivileges OUT
IF @OLEResult <> 0 PRINT 'Error create component OperatorPrivileges'

--Set a property of OperatorPrivileges.
EXECUTE @OLEResult = sp_OASetProperty @OperatorPrivileges, 'PropertyName', @SomeSQLValue
IF @OLEResult <> 0 PRINT 'PropertyName set problem'

--Get a value of a property of OperatorPrivileges.
EXECUTE @OLEResult = sp_OAGetProperty @OperatorPrivileges, 'PropertyName', @SomeSQLValue OUTPUT
IF @OLEResult <> 0 PRINT 'PropertyName get problem'

--Call some method of OperatorPrivileges.
EXEC @OLEResult = sp_OAMethod @OperatorPrivileges, 'MethodName', 
 @ReturnValue OUTPUT, @parameter1, @parameter2

5. Other programming environments

Please see documentation of your programing environment, work with COM objects (OLE objects, ActiveX objects). OperatorPrivileges is a standard COM object, it can work with other environments, such are Delphi or PowerBuilder.