With all Remote databases I try to create a local database view of the remote table. This way the ARS system doesn't have to deal with the fact that it is remote (which is a plus when you have a Dev/Test/Prod environment setup and you need to move your code between environments). In ARS you simply create a View form against the local view of the remote data.
Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Marc Burick Sent: Monday, September 12, 2011 11: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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
