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"