Home › Forum › Integrating PerfectForms › Using AutoComplete in a Connection action returns error
Tagged: Connection Agent, connection agent action, lookup
This topic contains 0 replies, has 0 voices, and was last updated by ijobling 12 years ago.
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’.
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
You must be logged in to reply to this topic.