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 :)) 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<http://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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"