000033082 - How to use the VBScript sample script of RSA Authentication Manager 8.1 SDK

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000033082
Applies ToRSA Product Set : SecurID
RSA Product/Service Type : RSA Authentication Manager
RSA Version/Condition: 8.1 Service Pack 1
Platform : SUSE Enterprise Linux
O/S Version : 11 Service Pack 3
Product Name :  SDK
Product Description : SecurID Appliance
IssueCustomer has a requirement to test the vbscript SQLsample.vbs which is provided as a sample from the RSA Authentication Manager 8.1 SDK and found in the <SDK_Directory>\samples\sql\vbscript folder of the unpacked software.
ResolutionTo run the sample vbscript SQLsample.vbs, a PostgreSQL unicode database driver is required. PostgreSQL unicode database drivers are available from the PostgreSQL website.
NOTE: it is already assumed that the RSA Authentication Manager 8.1 SDK has been extracted from the am-extras- file (downloadable from RSA SecurCare Online - Version Upgrades with a redirect to Download Central)
  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.1 Developer's Guide (available from am-extras- 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 (keeping 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 & 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 (found in Windows ODBC) e.g. {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.
User-added image
An example of running the updated vbscript where 2 is the parameter from the Windows command prompt (cmd.exe).
SQLsample.vbs 2

User-added image
User-added image
User-added image
User-added image
NotesVBScript ("Visual Basic Scripting Edition") is an Active Scripting language developed by Microsoft that is modelled on Visual Basic. Refer to Wikipedia for further information on Visual Basic Scripting Edition.