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: arslist@ARSLIST.ORG 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"
