MOTOBIT.COM - ASP upload, IIS utility DatabaseTypeEnum usage

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

1. Identities

Library name: RSConvert
Library code: RSConvert
Library CLSID: 17B59EB9-3CC2-11D4-9F56-204C4F4F5020
ProgID: RSConvert.DatabaseTypeEnum
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 DatabaseTypeEnum
Set DatabaseTypeEnum = CreateObject("RSConvert.DatabaseTypeEnum")
DatabaseTypeEnum.SomeMethod SomeParameters
DatabaseTypeEnum.SomeProperty = SomeValue

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

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

var DatabaseTypeEnum;
DatabaseTypeEnum = new ActiveXObject("RSConvert.DatabaseTypeEnum");
DatabaseTypeEnum.SomeMethod(SomeParameters)
DatabaseTypeEnum.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 DatabaseTypeEnum As New RSConvert.DatabaseTypeEnum
DatabaseTypeEnum.SomeMethod SomeParameters
DatabaseTypeEnum.SomeProperty = SomeValue
    ...

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

You can use CreateObject function also, of course:

Dim DatabaseTypeEnum As RSConvert.DatabaseTypeEnum
...
Set DatabaseTypeEnum = CreateObject("RSConvert.DatabaseTypeEnum")
DatabaseTypeEnum.SomeMethod SomeParameters
DatabaseTypeEnum.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 DatabaseTypeEnum object
 RSConvert.DatabaseTypeEnum DatabaseTypeEnum = new RSConvert.DatabaseTypeEnumClass(); 
 DatabaseTypeEnum.set_String("Some text value"); 
 





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

or (VBA)

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

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

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

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

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

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

5. Other programming environments

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