Thanks to all who replied... I will just probably create a new table on the Remedy database with the required field needed to create a remedy view form and I'll just have to update that table with the values from the view form from the linked server from time to time. It took me almost a month to get access from another department to their external database and permission to add it as a linked server. I may be better off doing the work on the remedy database side since I already have access to their view form and work from here. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Pulsen Sent: Friday, May 23, 2008 8:36 AM To: [email protected] Subject: Re: No available columns when creating a view form from SQL ** Without the REQUIREMENTS of the external db not having any column (field) that enforces non-null and unique values, you CAN NOT create the view form.
You need to talk to your dba's. Kevin. --- On Fri, 5/23/08, Kevin Pulsen <[EMAIL PROTECTED]> wrote: From: Kevin Pulsen <[EMAIL PROTECTED]> Subject: Re: No available columns when creating a view form from SQL To: [email protected] Date: Friday, May 23, 2008, 3:29 PM Just want to make sure of a couple of items. 1. You have created a Linked Server (From the AR database server) to your external database. (Are both of these db's SQL 2005?) 2. ARAdmin has rights to access the external database. Kevin P. ** When I hit load nothing shows up on the available columns list. The reason for that according to the manual is because the database view must contain an integer or character field that enforces no null value and unique to act as the request ID field and I don't have a column(field) that meets that requirement on my database view. I do have a field that is unique that I can use how do I change the type of that field to enforce the no null value? __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
