ConvertCodePages usage

Article | Member of ScriptUtils.ConvertCodePages | Changes | Purchase | Download

1. Identities

Library name: Script Utilities library
Library code: ScriptUtilities
Library CLSID: 41ABB943-5D82-11D3-9DD5-204C4F4F5020
ProgID: ScriptUtils.ConvertCodePages
Library file name: ScptUtl.DLL

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

You can create the object using CreateObject function:

Dim ConvertCodePages
Set ConvertCodePages = CreateObject("ScriptUtils.ConvertCodePages")
ConvertCodePages.SomeMethod SomeParameters
ConvertCodePages.SomeProperty = SomeValue

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

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

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

Dim ConvertCodePages As New ScriptUtilities.ConvertCodePages
ConvertCodePages.SomeMethod SomeParameters
ConvertCodePages.SomeProperty = SomeValue
    ...

Dim ConvertCodePages As ScriptUtilities.ConvertCodePages
...
Set ConvertCodePages = New ScriptUtilities.ConvertCodePages
ConvertCodePages.SomeMethod SomeParameters
ConvertCodePages.SomeProperty = SomeValue
...

You can use CreateObject function also, of course:

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

 //create  a new ConvertCodePages object
 ScriptUtilities.ConvertCodePages ConvertCodePages = new ScriptUtilities.ConvertCodePagesClass(); 
 ConvertCodePages.set_String("Some text value"); 
 





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

or (VBA)

Dim ConvertCodePages As New ScriptUtilities.ConvertCodePages 
ConvertCodePages.SomeMethod(SomeParameters)
ConvertCodePages.SomeProperty = SomeValue

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

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

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

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

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

5. Other programming environments

Please see documentation of your programing environment, work with COM objects (OLE objects, ActiveX objects). ConvertCodePages 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