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"
