Keep in mind that the editor and data adapter works differently. Also, is the user that you are using in the external connection does that user got write access to the tables?
Yes, that user has write access.
What is the error you are getting then? Prior releases won't let you write to a different schema. But I guess you are not on that version.
I am just trying a connection from Table editor and getting below error. I am on version 6.4.
Your data adapter does have aliasing on the SELECT statement. What if you remove the alias as do SELECT * from error_codes? Does that work?
