MOTOBIT.COM - ASP upload, IIS utility MDB usage

Article | Member of RSConvert.MDB | Changes | Purchase | Download

1. Identities

Library name: RSConvert
Library code: RSConvert
Library CLSID: 17B59EB9-3CC2-11D4-9F56-204C4F4F5020
ProgID: RSConvert.MDB
Library file name: RSConv.dll

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

You can create the object using CreateObject function:

Dim MDB
Set MDB = CreateObject("RSConvert.MDB")
MDB.SomeMethod SomeParameters
MDB.SomeProperty = SomeValue

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

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

var MDB;
MDB = new ActiveXObject("RSConvert.MDB");
MDB.SomeMethod(SomeParameters)
MDB.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 'RSConvert' in the listbox (or Project -> References -> Browse -> select RSConv.dll file).
MSAccess, Word, Excel: Tools -> Macro -> Visual Basic Editor, then Tools -> References
Then you can write:

Dim MDB As New RSConvert.MDB
MDB.SomeMethod SomeParameters
MDB.SomeProperty = SomeValue
    ...

Dim MDB As RSConvert.MDB
...
Set MDB = New RSConvert.MDB
MDB.SomeMethod SomeParameters
MDB.SomeProperty = SomeValue
...

You can use CreateObject function also, of course:

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

 //create  a new MDB object
 RSConvert.MDB MDB = new RSConvert.MDBClass(); 
 MDB.set_String("Some text value"); 
 





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

or (VBA)

Dim MDB As New RSConvert.MDB 
MDB.SomeMethod(SomeParameters)
MDB.SomeProperty = SomeValue

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

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

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

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

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

5. Other programming environments

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