Hello Victor, That is what I suspected with the invalid identifier error.. if your table was not recognized it would be invalid table or view name error which is not your case.. Which is why the later part of my previous email holds good.. Take a SQL log, you may find that offending column name or columns..
There is something in the way that ARS is naming the offending column or columns causing that error.. When you find what column it is email the list or me directly and we'll try to figure it out.. you might need to create a independent view in MS-SQL of that table having names of fields that are legal to use in case there is a column name there that the ARS converts into something else.. This is just a speculative solution, we'll know more when you know more.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Victor Sent: Thursday, December 10, 2009 3:00 PM To: arslist@ARSLIST.ORG Subject: Re: View form from Oracle based AR system to remote MS SQL server Thanks Joe, I will try all you said and have you posted tomorrow(I'm out of office at the moment) but I want to point out that will creating the view form I was able to load the table and the pick the fields required for the form. Only when I pressed "Create" the error occurred. .. and furthermore the ms sql username and password was hard-cored into the public DB link created Victor _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
