000015479 - Successfully execute SQLsample.vbs sample database query script

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

Article Content

Article Number000015479
Applies ToAuthentication Manager version 7.1
Service Pack 3
SP3
SQLsample.vbs
IssueSuccessfully execute SQLsample.vbs sample database query script

C:\test>cscript sqlsample.vbs 4
Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation. All rights reserved.

Running Simple Query

QuerySQL = SELECT * from RSA_REP.IMS_PRINCIPAL_DATA

Output File: SimpleQuery.csv

C:\test\sqlsample.vbs(368, 3) Microsoft OLE DB Provider for ODBC Drivers: [Mic
rosoft][ODBC driver for Oracle][Oracle]ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

CauseThe sample's connection setup information has incorrectly defined the AM_DB_Service variable with <SID>.ims.rsa.
ResolutionEnsure that the script's AM_DB_Service variable is assigned a value of the form:

AM_DB_Service= "wcuy3sxh"    'without the .ims.rsa suffix

Legacy Article IDa50755

Attachments

    Outcomes