How to use the VBScript sample script of RSA Authentication Manager 8.x SDK

[#1]

Article Number

000033082

Applies To

RSA Product Set:  SecurID
RSA Product/Service Type:  Authentication Manager SDK
RSA Version/Condition:  8.x
 

Issue

There is a requirement to test the VBScript SQLsample.vbs which is provided as a sample from the RSA Authentication Manager 8.x SDK and found in the <SDK_Directory>\samples\sql\vbscript folder of the unpacked software.

Resolution

To run the sample VBScript SQLsample.vbs, a PostgreSQL unicode database driver is required. PostgreSQL unicode database drivers are available from the PostgreSQL website.

Steps

it is already assumed that the RSA Authentication Manager 8.x SDK has been extracted from the am-extras-8.x.0.0.0.zip file (downloadable from RSA Link).

1. Download and install the PostgreSQL unicode database driver on a Windows platform.
2. Create a read-only user for RSA Authentication Manager internal database access. The RSA Authentication Manager 8.x Developer's Guide (available in the am-extras-8.1x.0.0.0.zip) has a section called "SQL Access to the RSA Authentication Manager Database" that has this procedure of creating a read-only user.
3. Make a copy of SQLsample.vbs for your own use. Be sure to keep a copy of the original file.
4. Update the AM Database Connection Parameters to match the Authentication Manager primary instance (changing the AM_Hostname, AM_DB_RptUser and AM_DB_RptPass).
5. [Optional] Update the Active Directory Identity Source Parameters.
6. Make a modification to the AM DB Connection String. Change {PostgreSQL Unicode} to match the PostgreSQL unicode database driver that is found in Windows ODBC; for example:  {PostgreSQL Unicode(x64)}.
7. Save the changes and run the updated VBScript.

A usage message will appear where no parameters are provided when running the updated VBScript:

Image description

An example of running the updated VBScript where 2 is the parameter from the Windows command prompt:

SQLsample.vbs 2

Image description

Image description

Image description

Image description
 

Notes

VBScript is an Active Scripting language developed by Microsoft that is modeled on Visual Basic. Refer to Wikipedia for further information on Visual Basic Scripting Edition.