0 Replies Latest reply on Aug 2, 2013 7:41 AM by JoshSamuels

    ODBC Not Working

    JoshSamuels

      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