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
ckattookaran's avatar
ckattookaran
VIP
4 years ago

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?

  • 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.