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"
