AnsweredAssumed Answered

ODBC Not Working

Question asked by JoshSamuels on Aug 2, 2013

Summary

ODBC Not Working

Product

FileMaker Pro

Version

12

Operating system version

OSX 10.6.8

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

Expected result

Working ODBC Connection

Actual result

Error Message, no ODBC Connection

Exact text of any error message(s) that appear

The ODBC data source you have selected is not supported.

Details:
[8310] Driver error: 42000

[FileMaker][FileMaker] FQL0001/(1:47): There is an error in the syntax of the query.

Screen_shot_2013-08-02_at_10.41.21_AM.png

Outcomes