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
