MOTOBIT.COM - ASP upload, IIS utility Server usage

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

1. Identities


Library name: ActiveX UserManager 1.7
Library code: UserManager
Library CLSID: E5D2CE13-5FA0-11D2-A666-204C4F4F5020
ProgID: UserManager.Server
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 Server
Set Server = CreateObject("UserManager.Server")
Server.SomeMethod SomeParameters
Server.SomeProperty = SomeValue

   You can also use CreateObject method method of Server object (ASP) to put the Server 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="Server"
 progid="UserManager.Server">
</object>

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

var Server;
Server = new ActiveXObject("UserManager.Server");
Server.SomeMethod(SomeParameters)
Server.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 Server As New UserManager.Server
Server.SomeMethod SomeParameters
Server.SomeProperty = SomeValue
    ...
or
Dim Server As UserManager.Server
...
Set Server = New UserManager.Server
Server.SomeMethod SomeParameters
Server.SomeProperty = SomeValue
...
You can use CreateObject function also, of course:
Dim Server As UserManager.Server
...
Set Server = CreateObject("UserManager.Server")
Server.SomeMethod SomeParameters
Server.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 Server object
UserManager.Server Server = new UserManager.ServerClass();
Server.set_String("Some text value");






String SQL;
SQL = "Insert Into Table (BinaryColumn) values (0x" + Server.get_HexString() + ")"; ...
or (VBA)
Dim Server As New UserManager.Server 
Server.SomeMethod(SomeParameters)
Server.SomeProperty = SomeValue

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

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

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

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

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

5. Other programming environments

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

© 1996 - 2009 Antonin Foller, Motobit Software | About, Contacts | e-mail: info@pstruh.cz