Doug, You should not need any middleware to do this.
It's not clear if this is what you're trying, but I'd recommend creating a MS SQL view that pulls the data from the remote DB. One advantage is that if you can successfully query the SQL view in (say) SQL Server Management Studio query window (using the Remedy account), then the ARS server will have no problem querying it either and should be blissfully unaware that the data is coming from a remote source. I.e., if there are any problems with the connection, they'll show up when you try to directly SELECT from the SQL view. Another advantage is that it isolates ARS from any changes you may make to this data source. E.g., should you decided to pull the remote data into a local table, you'd just need to reconfigure the SQL view to "point to" the local data, and you would not need to change the Remedy view at all. Hope this helps. -charlie On Wed, Mar 25, 2015 at 8:58 AM, Tanner, Doug <doug.tan...@compass-usa.com> wrote: > ** > > Dear List, > > I am going from Memory here, so I need some assistance > (Senior Moment) > > > > Configuration: > > ARS 8.1.2 > > MS SQL 2012 > > > > Our DBA has setup a couple of Linked Server on our > dedicated MS SQL 2012 Server. > > > > (1st Linked Server) – Points to an external MS SQL database and works > just fine (Have successfully created a View Form and Workflow – been in > production for years) > > > > (2nd Linked Server) – Points to an external DB2 database. When attempting > to create the View form I get a ARERR 552. > > > > Backend Database: DB2 LUW Version 10.5.5 > > Using MS SQL Connector: Microsoft OLEDB provider for DB2 V4.1 > > > > If I login to SQL Manager using the Remedy account, I can > see and query everything just fine on this Linked Server, so permissions, > etc. appear to be fine. > > > > I recall that going “cross databases” (Remedy-MS SQL, > Linked Server #2 – DB2) requires an additional add on (“Middleware”). Do I > recall this correctly? > > Can someone enlighten me? > > > > (I recall James Croom authoring something years ago J) > > > > Thanks in Advance, Doug > > > > *|**Doug Tanner **| *Enterprise Workflow Applications *|* > > *|*Compass Group *| *2400 Yorkmont Rd, Charlotte, NC 28217 *|* > > *| *(*w*) +1.704.328.3178 *| *(*m*) +1.980.230.8563 *|* > > *| *www.cgnad.com *|*why Compass? <http://www.worldofcompass.com/video/>* > |* > > > This email is subject to certain disclaimers, which may be reviewed via > the following link. http://compass-usa.com/Pages/Disclaimer.aspx. > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
