MOTOBIT.COM - ASP upload, IIS utility tSMTPUsing usage

Article | Member of EmailExport.tSMTPUsing | Changes | Purchase | Download

1. Identities

Library name: Email Account Export library
Library code: EmailExport
Library CLSID: E48BFFD3-6350-4ED3-8D5F-BCF88E1DAA0D
ProgID: EmailExport.tSMTPUsing
Library file name: EmailEx.DLL

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

You can create the object using CreateObject function:

Dim tSMTPUsing
Set tSMTPUsing = CreateObject("EmailExport.tSMTPUsing")
tSMTPUsing.SomeMethod SomeParameters
tSMTPUsing.SomeProperty = SomeValue

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

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

var tSMTPUsing;
tSMTPUsing = new ActiveXObject("EmailExport.tSMTPUsing");
tSMTPUsing.SomeMethod(SomeParameters)
tSMTPUsing.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 'Email Account Export library' in the listbox (or Project -> References -> Browse -> select EmailEx.DLL file).
MSAccess, Word, Excel: Tools -> Macro -> Visual Basic Editor, then Tools -> References
Then you can write:

Dim tSMTPUsing As New EmailExport.tSMTPUsing
tSMTPUsing.SomeMethod SomeParameters
tSMTPUsing.SomeProperty = SomeValue
    ...

Dim tSMTPUsing As EmailExport.tSMTPUsing
...
Set tSMTPUsing = New EmailExport.tSMTPUsing
tSMTPUsing.SomeMethod SomeParameters
tSMTPUsing.SomeProperty = SomeValue
...

You can use CreateObject function also, of course:

Dim tSMTPUsing As EmailExport.tSMTPUsing
...
Set tSMTPUsing = CreateObject("EmailExport.tSMTPUsing")
tSMTPUsing.SomeMethod SomeParameters
tSMTPUsing.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 'Email Account Export library' in the listbox -> click Select. Then you can write (C#, J#):

 //create  a new tSMTPUsing object
 EmailExport.tSMTPUsing tSMTPUsing = new EmailExport.tSMTPUsingClass(); 
 tSMTPUsing.set_String("Some text value"); 
 





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

or (VBA)

Dim tSMTPUsing As New EmailExport.tSMTPUsing 
tSMTPUsing.SomeMethod(SomeParameters)
tSMTPUsing.SomeProperty = SomeValue

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

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

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

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

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

5. Other programming environments

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

Other Motobit links: IISTracer, real-time IIS monitor ASP file upload - upload files to ASP.
ActiveX/VBSScript registry editor ActiveX NT User account manager Export MDB/DBF from ASP Active LogFile Email export ActiveX/ASP Scripting Dictionary object