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

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Aug 9, 2019
Version 6Show Document
  • View in full screen mode

Article Content

Article Number000033082
Applies ToRSA Product Set:  SecurID
RSA Product/Service Type:  Authentication Manager SDK
RSA Version/Condition:  8.x
 
IssueThere 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.
ResolutionTo 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:

User-added image

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


SQLsample.vbs 2


User-added image

User-added image

User-added image

User-added image
 
NotesVBScript 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.

Attachments

    Outcomes