Using AutoComplete in a Connection action returns error

Home Forum Integrating PerfectForms Using AutoComplete in a Connection action returns error

This topic contains 0 replies, has 0 voices, and was last updated by  ijobling 9 years, 7 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #181

    ijobling
    Participant

    When trying to Auto complete table fields in a DB connection action, after confirming that the connection itself returns ok and the correct name for the Database Table is entered an error of

    2009-05-07 10:34:22 – vx.xx.xx – IP:xx.xx.xx.xx – /GetColumnNames – login1

    ERROR: SQLException in GetColumnNames service:Invalid object name ‘<tablename’.

    net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

    net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)

    net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)

    A: Usually indicates that the access rights to this table are not sufficient

    From your config.xml file .. there you are defining the sql user account to use.. check that this user has the appropriate level of access – your DBA’s should be able to help you there

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.