I am not sure to which user you are referring. Any sql menu will run as the db user that remedy is configured to use to connect to the db.
Axton On 7/29/07, Ray <[EMAIL PROTECTED]> wrote: > Hi Axton: I donot see anything in arerror.log. I have enabled logging on > the remedy user client and donot see anything there as well. Not sure if > his matters. This REMEDY user is not one created by remedy. It's a user > our db admin has created for readonly access to a few views and tables. > > Thanks > Ravi > Axton wrote: > > 1. Is there anything else I need to do for the SQL menu to work? > > Shouldn't be > > > > 2. How does the sql menu know what is the password for the REMEDY user > > in the database? > > It already has sessions to the Oracle instance used by Remedy; it just > > uses those > > > > 3. How does it know the ORACLE_SID to be used for this query? > > It already has sessions to the Oracle instance used by Remedy; it just > > uses those, meaning it runs the sql against the Remedy instance as the > > remedy schema owner > > > > Your arerr90 is more than likely indicative of another problem. Check > > the arerror.log file for more info. > > > > Axton Grams > > > > On 7/29/07, Ray <[EMAIL PROTECTED]> wrote: > > > >> Hi: I have created a menu that should list value for all fields in a > >> database. The SQL command for the menu I am using is the following. > >> > >> select distinct(LOCATION) from REMEDY.LOCATIONS > >> > >> I have associated this menu with a field in my form. When I click on the > >> pulldown menu for the field, I get the following error > >> > >> ARERR [90] Cannot establish a network connection to the AR System server > >> : 192.168.2.219 (0) : RPC: Program not registered > >> > >> The database I am connecting to is the database remedy uses and the > >> database runs on a different server. I can log into that database fine > >> using a sqlplus client. > >> > >> 1. Is there anything else I need to do for the SQL menu to work? > >> 2. How does the sql menu know what is the password for the REMEDY user > >> in the database? > >> 3. How does it know the ORACLE_SID to be used for this query? > >> > >> Thanks > >> Ray > >> > >> _______________________________________________________________________________ > >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > >> the Answers Are" > >> > >> > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > > the Answers Are" > > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"