Brooks, Try to log into the database as ARAdmin, which is the user that owns the ARSystem database, then try to query the table. If you get an error it could possibly mean that the dblink you have created is not accessible by ARAdmin. A view form when created from Remedy uses the database permissions of ARAdmin when accessing the object so any object that cannot be accessed by ARAdmin will not be accessible from the AR System.
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of brooksm Sent: Wednesday, August 15, 2007 4:05 PM To: [email protected] Subject: How to create a view form My ARSystem is on a SQL Server 2005 database and I need to create a view form of an external table/view. I've already set up the dblink and created a view of the external table. I'm having problems with the correct syntax when creating the view form. Database = ARSystem Schema = dbo So far i've tried these all unsuccessfully: ARSYSTEM.DBO.ALTIRIS_VIEW ARSYSTEM.ALTIRIS_VIEW ARSYSTEM..ALTIRIS_VIEW ALTIRIS_VIEW Can someone advise what the problem might be? Thanks Brooks No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.19/953 - Release Date: 8/14/2007 5:19 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
