ODBC Not Working
Operating system version
Description of the issue
When attempting to add an ODBC DSN as a data source for a table error returned
DSN tests successfully in Filemaker Driver and the software that I am attempting to make a connection with (Vectorworks 2013) sees the DSN and the Filemaker database, but also returns an error when attempting to transfer data through the DSN
Steps to reproduce the problem
1. Create and Test DSN through Filemaker ODBC Driver
2. Add ODBC DSN as external data source in FIlemaker
3. Use DSN as source for table in Filemaker
Working ODBC Connection
Error Message, no ODBC Connection
Exact text of any error message(s) that appear
The ODBC data source you have selected is not supported.
 Driver error: 42000
[FileMaker][FileMaker] FQL0001/(1:47): There is an error in the syntax of the query.