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"