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"
