JDBC driver keyword/syntax issue

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)

I did a little poking around in the forums and came up with this thread. I don’t know if you have seen it or not, but it may be of some use.

inductiveautomation.com/forum/vi … =70&t=5960

In this thread Carl suggests using a JDBC driver versus going the ODBC route. You might want to give this a try.

I think what you are saying is to use a JDBC Type 4 vs any other JDBC Type (1-3) driver? Thanks for the clarification.