Hi Marc,
We are using quite a few view forms although none of them are SQL Server only Oracle based tables with our Remedy also using an Oracle database. However your dba may be able to help set this up - have you tried creating a synonym in the remedy schema that points to the table you want to reference? We have done similar setup for other applications in the reverse direction with Oracle tables referenced as if they are part of SQL Server database this approach should work the other way around but may require some setup/work on the Oracle side for access to SQL Server as the Oracle methods for this are not as straightforward as the reverse with SQL Server access to Oracle objects. Take Care, Debra From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Marc Burick Sent: Monday, September 12, 2011 9:00 AM To: [email protected] Subject: Getting errors when creating a View Form ** ARServer 7.1, patch 1 Admin Tool,, 7.1 patch 11 SQL 2008 We are attempting to create our first View Form, SQL database to a Oracle database, but we can not create the form. I am pretty sure our problem is the syntax of the table that I am putting in the field before I press Load. The Admin Tool appears to be looking for sysobjects, instead of the Linked Server. The examples in the documentation are poor. Admin Tool error message: Failure during SQL operation to the database : PAEHOWUD351.ASSETCENTER.AC_REMEDY_ASSETLOOKUP_VIEW (ARERR 552). SQL log error message: <SQL > <TID: 0000003088> <RPC ID: 0000002030> <Queue: Admin > <Client-RPC: 390600 > <USER: D065879 > /* Mon Sep 12 2011 11:57:52.7910 */SELECT id from PAEHOWUD351.dbo.sysobjects where name = N'AC_REMEDY_ASSETLOOKUP_VIEW' <SQL > <TID: 0000003088> <RPC ID: 0000002030> <Queue: Admin > <Client-RPC: 390600 > <USER: D065879 > /* Mon Sep 12 2011 11:57:52.7910 */*** ERROR *** Invalid object name 'PAEHOWUD351.dbo.sysobjects'. (SQL Server 208) We are able to query the Linked Server from SQL Studio. I am able to create a view on the SQL server that looks at the Linked Server and create the View Form using that view, but when I run a selection from the View Form, it takes 50+ seconds. Can anyone provide the syntax that should be put in as the table we want to be pointing to? Again, the documentation is not very clear. Thank you in advance. Marc _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
