Forum Discussion

Sridhar_M's avatar
Sridhar_M
Contributor
4 years ago

SQL Table Editor connecting to External Database not working

Hi, Can anyone explain why External connection is not working in SQL Table Editor ? The same connection is working for Data Adapter. Screenshot for Data Adapter and it’s working.   Screensh...
Planning
Sridhar_M's avatar
Sridhar_M
Contributor
4 years ago

Yes, that user has write access. 

ckattookaran's avatar
ckattookaran
VIP
4 years ago

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.

  • Sridhar_M's avatar
    Sridhar_M
    Contributor
    4 years ago

    I am just trying a connection from Table editor and getting below error. I am on version 6.4. 

     

    • ckattookaran's avatar
      ckattookaran
      VIP
      4 years ago

      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?

       

      • Sridhar_M's avatar
        Sridhar_M
        Contributor
        4 years ago

        No, I am getting below error message if I don't use fully qualified name (ailas) in Data Adapter.