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"

Reply via email to