Brooks, In which database did you create the view?
Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of brooksm Sent: Wednesday, August 15, 2007 4:49 PM To: arslist@ARSLIST.ORG Subject: Re: How to create a view form I was logged in as SA. I've tried SA.ALTIRIS_VIEW, but get this error: Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481). I've verified the case sensitivity in the tablename was correct (it should be all caps). Kevin Gallagher wrote: > > Who were you logged in as when you created the view in your database? > It is most likely login.view. For example aradmin.ALTIRIS_VIEW. > > You also might want to check the permissions on the view and make sure > the aradmin account has permission to read and write it. > > > --- brooksm <[EMAIL PROTECTED]> wrote: > >> 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 >> -- >> View this message in context: >> > http://www.nabble.com/How-to-create-a-view-form-tf4275357.html#a12169275 >> Sent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> >> > ________________________________________________________________________ _______ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> ARSlist:"Where the Answers Are" >> > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/How-to-create-a-view-form-tf4275357.html#a12170062 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"