Ray, There are so many ways this could have been set up within Oracle. It could be just a table in the same Oracle instance as your AR System tables. It could have been set up with a link from one instance to another. Depending on how the DBA's set it up can make a difference on the actual select statement.
Best advice I can offer is talk to your DBA's. Dave -------------------------- [EMAIL PROTECTED] (Wireless) ----- Original Message ----- From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> To: arslist@ARSLIST.ORG <arslist@ARSLIST.ORG> Sent: Sun Jul 29 17:49:33 2007 Subject: Re: Newbie help with creating a SQL menu 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) <arslist@ARSLIST.ORG> > To: arslist@ARSLIST.ORG <arslist@ARSLIST.ORG> > 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"