Hi Robert, Exactly my point, I am getting a response from the server.
We've double checked the drivers and they are the same on both sever and client. Directly from the FM updater_11.0.3.312. I'm querying the correct columns from the PersonnelFile table, which are displayed without a hitch in both Witango and Terascibe, and I've double checked my SQL statement and it is accurate. I have no clue what this error means. On 8/17/11 12:12 PM, "Robert Shubert" <rshub...@tronics.com> wrote: Terry, Are you using FileMaker 11.3? Are the ODBC/JDBC drivers at the same version as the server? (this is critical) Is the SQL statement incorrect? (column and table named correct, etc) The good news is that you are getting a response from the server (or at least the ODBC subsystem). Robert -----Original Message----- From: Lipford, Terencia (NIH/CIT) [C] [mailto:lipfo...@mail.nih.gov] Sent: Wednesday, August 17, 2011 11:55 AM To: Witango-Talk@witango.com Subject: Witango-Talk: Filemaker Pro Syntax error My first time attempting to run queries against Filemaker Pro via Witango 5.5 and Terascibe 6. I have successfully connected from Witango 5.5 and Terascribe to the Filemaker Pro DB using ODBC and JDBC, however when I run my DBMS query: SELECT Last,First FROM PersonnelFile WHERE Last='xxxxx' I receive this error message: [Error][201] 8310 [FileMaker][FileMaker ODBC] FQL0001/(1:8): There is an error in the syntax of the query. 42000 Both Filemaker Network sharing and ODBC/JDBC sharing is ON What am I missing? -- Thank you, Terry Lipford NIH Intramural Database (NIDB) 301-402-8307 lipfo...@mail.nih.gov ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body.
