I can query this view without any problems in the SQL Server Management studio. I've also tried just using the view name but still nothing.
Carter, Craig J Civ ARPC/DPD wrote: > > Since you've already created the local view against the external table, > can you open that view in Management Studio and pull data successfully? > You could have a problem with DTS default settings, etc. > > If so, you should be able to simply enter the view name unless you built > the view in another database. Did you create the view in the ARSystem > database (assume so based on your information below)? > > The view form will try to read the view to populate the columns list so > make sure you can pull data with the view via SQL before trying to > create the view form. We have several of these and we simply enter the > view name with no prefixes when we create the view form. > > //SIGNED// > CRAIG J. CARTER, RSP > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of brooksm > Sent: Wednesday, August 15, 2007 2: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 > -- > 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#a12169937 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"
