The bugfix they sent me for patch 2 makes it possible to query against a condition on the AR Server - in my case it was in the Query tab, Data Key Query tab, AR Form Query where I had $Corporate ID Right$ = "0" as a condition for the data exchange to run. This was not a problem in 7.1 or patch 001, and is supposed to be fixed in patch 003, but if this is your problem BMC has a hotfix for the problem... a newer eie.exe and two dlls. The oradpr.dll was one of the changed files (the sql server adapter was not).
Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brian Gillock Sent: Saturday, June 21, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Hey Howard, I'm afraid I don't have any tidbits regarding Oracle, but having been brutalized by the AIE over the past 3 days, I can tell you that patch 2 isn't very cooperative. I have finally had success by dropping back to patch 1. This may not help you, but I figured it can't hurt to share my experience. Good Luck! Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Saturday, June 21, 2008 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: Issue with AIE and Oracle ** Happy weekend to all, I have tried everything I can think of and BMC as well, it might be a bug of some kind. Using the command line it work. I will post was BMC comes back with. Howard On Thu, Jun 19, 2008 at 6:08 PM, Joe DeSouza <[EMAIL PROTECTED]> wrote: ** Have you entered your oracle configurations correctly in the helper utility that is bundled with AIE? Oracle home, SID, username, password?? Joe ----- Original Message ---- From: Howard Richter <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, June 19, 2008 9:49:51 AM Subject: Issue with AIE and Oracle ** Good morning all, I have the newest release of AIE and I am trying to get it to talk to a remote oracle database. The Server is 7.1 patch 3 and using MSSQL. I have installed the 10g client and can talk to the remote Oracle system using sqlplus from the box where the arserver is running. There is nothing in any log that I can find, that shows any attempt of the AIE trying to connect to the Oracle database. I did try setting up the AIE to talk to a MSSQL database and that worked. I am starting to wonder if, you can only talk to a database that the server talks to (for example in my case only MSSQL, since that is what the server is talking to). Any ideas, as of yet BMC support has had non. Howard -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn <http://www.linkedin.com/> Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = [EMAIL PROTECTED] LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
