Axton, Dave: I changed the Server name to the IP address of the remedy
server instead of the database server and it works. Any idea if I can
connect to a database table that is not the remedy database? If yes, how
would I do that?
Thanks
Ray
Shellman, David wrote:
Ray,
My suggestion is to connect to your AR System instance with SQL Plus
as the user aradmin. Then execute the sql statement. This eliminates
any issue with the AR System. Any resulting Oracle error will be
displayed.
If the table doesn't have a public synonym you will proably need to
execute the sql statement in the form of select value from
[EMAIL PROTECTED] I remember this after I try select
select value from [EMAIL PROTECTED] and get a table doesn't exist error.
Often the other instance may require the same user name aradmin
instead of a user named remedy. There's probably a way to connect as
another user but I haven't tried and it may complicate the sql statement.
Dave
--------------------------
[EMAIL PROTECTED] (Wireless)
----- Original Message -----
From: Action Request System discussion list(ARSList) <[email protected]>
To: [email protected] <[email protected]>
Sent: Sun Jul 29 13:13:51 2007
Subject: Re: Newbie help with creating a SQL menu
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
Ray
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"
