Even if you have the proper DB information you will need a username and password to connect directly to the DB. DBA's historically are very tight with that sort of account because it can cause massive performance issues if you start issuing bad queries to the backend which may cause Remedy to crawl. What type of work are you trying to do that CR or the Remedy client won't allow? You can use Access as well if you would like...but without the DB information you will still need to go through the ODBC.
L. J. Head Software Engineer Remedy Approved Consultant -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chris Sent: Tuesday, October 17, 2006 2:04 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy and TNSNAMES.ora I think maybe I should have been a bit more clear. I'm not administering anything, simply trying to connect to the oracle database that is feeding Remedy (TOAD, SQLPlus, any tool realy, I just would like to connect to it though a program other than ARS or Crystal Reports). My real question was, can I figure this out by looking at settings I have, or do I need to go to the DBA, since my boss doens't even know who the DBA is (ownership of our Remedy system was recently transfered), I was hoping that I could get this information without having to go that route. It looks like I do. Thanks for the information. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org