sumware

Wild card searches via ODBC failing

Discussion created by sumware on Oct 17, 2013
Latest reply on Oct 20, 2013 by sumware

Client has a FileMaker Server Advanced (Windows 2008R2) enabled for ODBC queries and appropriate privileges set. I believe the correct drivers are installed (the ones that came with the installation, which are identical to the current downloads).

 

This query of the server works:

 

SELECT p_IDClient, p_nameFirst, p_nameLast

FROM people

WHERE p_nameLast = 'Smith'

 

as does

 

SELECT p_IDClient, p_nameFirst, p_nameLast

FROM people

WHERE p_nameLast LIKE 'Smith'

 

But, putting in a wild card like so:

 

SELECT p_IDClient, p_nameFirst, p_nameLast

FROM people

WHERE p_nameLast LIKE '%it%'

 

 

gives an ODBC Error: "There is an error in the syntax of the query".

 

We have tried every form of the above that we can think, but to no avail. The syntax looks great and, if we fire up the FileMaker query builder in a remote copy of FileMaker Pro, the syntax generated is exactly the same as one of the failing queries we tried.

 

I feel that this is a driver issue, but not sure where to go from here!

 

Thanks for any suggestions.

 

Rob

Outcomes