Using FoxPro connected via JDataConnect, the following error is returned. Test was performed with Designer db tool. Also noted, the schema does not return the column names as keyword ‘COLUMN_SIZE’ is not recognized. Any ideas?
ERROR [QueryBrowser$5$3-AWT-EventQueue-0] <HTML>Error running query:<br>SELECT * FROM mmrawmat<br>ServerException:[ODBC Error], SQLExecDirect DBVendorCode:219:, DBState:37000:. [Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword.
com.inductiveautomation.ignition.client.gateway_interface.GatewayException: ServerException:[ODBC Error], SQLExecDirect DBVendorCode:219:, DBState:37000:. [Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword.
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.newGatewayException(GatewayInterface.java:313)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:287)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.sendMessage(GatewayInterface.java:244)
at com.inductiveautomation.ignition.client.gateway_interface.GatewayInterface.runLimitQuery(GatewayInterface.java:712)
at com.inductiveautomation.ignition.designer.querybrowser.QueryBrowser$5.run(QueryBrowser.java:401)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: ServerException:[ODBC Error], SQLExecDirect DBVendorCode:219:, DBState:37000:. [Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword.
at JData4_0.sql.$Connection.FromServer(null)
at JData4_0.sql.$Connection.ToServer(null)
at JData4_0.sql.$Statement.Send(null)
at JData4_0.sql.$Statement.DoExecute(null)
at JData4_0.sql.$Statement.executeQuery(null)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at com.inductiveautomation.ignition.gateway.datasource.DelegatingStatement.executeQuery(DelegatingStatement.java:63)
at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRStatement.executeQuery(SRConnectionWrapper.java:655)
at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.RunQuery.run(RunQuery.java:98)
at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.AbstractDBAction.invoke(AbstractDBAction.java:76)
at com.inductiveautomation.ignition.gateway.servlets.Gateway.doPost(Gateway.java:373)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.inductiveautomation.ignition.gateway.bootstrap.MapServlet.service(MapServlet.java:85)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(null)