Terry,
Can you build a TAF with a Custom SQL Query and do some simple tests, like
Select 1
Or
Select count(*) from PersonnelFile
Just try "stepping into" your statement to determine where the syntax error is.
One of the biggest points of grief with FM is that their ODBC and JDBC errors
are not well defined.
Also, could you verify the Witango/TeraScript server version and platform for
me.
Thanks,
Robert
-----Original Message-----
From: Lipford, Terencia (NIH/CIT) [C] [mailto:[email protected]]
Sent: Wednesday, August 17, 2011 12:26 PM
To: [email protected]
Subject: Re: Witango-Talk: Filemaker Pro Syntax error
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" <[email protected]> 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:[email protected]]
Sent: Wednesday, August 17, 2011 11:55 AM
To: [email protected]
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
[email protected]
----------------------------------------
To unsubscribe from this list, please send an email to [email protected]
with "unsubscribe witango-talk" in the body.
----------------------------------------
To unsubscribe from this list, please send an email to [email protected]
with "unsubscribe witango-talk" in the body.
----------------------------------------
To unsubscribe from this list, please send an email to [email protected]
with "unsubscribe witango-talk" in the body.
----------------------------------------
To unsubscribe from this list, please send an email to [email protected]
with "unsubscribe witango-talk" in the body.
