3 Replies Latest reply on Sep 23, 2014 9:40 AM by TSGal

    ODBC Connection issues in Filemaker 12 and 13 Server and FMP

    JoshHyman

      Summary

      ODBC Connection issues in Filemaker 12 and 13 Server and FMP

      Product

      FileMaker Pro

      Version

      12, 13

      Operating system version

      Mac osx 10.9.4 and Windows 7

      Description of the issue

      Hi There Folks,

      I have an issue I am seeking some help with around ODBC and Filemaker 13.

      I am trying to connect to a MS Sql database (R2 2008) with a filemaker 13 server machine (Mac 10.8.5) (for purposes of testing I have also tried FMA 13 on a macbook with 10.9 installed) and have the DSN name all setup and working fine on the server as well as the macbook, I can test this connection with Excel and with Filemaker 11 and all seems to function just fine.

      The issues come when adding an external data source in Manage Database in FM12 or FM13, I try to add the source table and I get the following error ODBC Error: [Actual][SQL Server] Unknown Host Machine Name.  [Actual][SQL Server] Unable to connect to data source.

      The weird thing is If I convert a Filemaker 11 file that already has the SQL data source defined in the relationship graph, it will find the data and work as expected, it will even let me define a new table from the same SQL source once converted to a fmp.12 file. If I try this process in a file created with FM 12 or 13 I get the same error as above. As the my main file is already pretty comprehensive I would hate to have to build it up again from a newly converted FM11 file just to gain the SQL functionality.

      Any help here would be greatly appreciated.

      Cheers

      Josh

      Steps to reproduce the problem

      Setup a DSN with valid and supported drivers
      Try to add a shadow table in the relationship graph
      Receive error message

      Expected result

      The Table should show data results

      Actual result

      Error message

      Exact text of any error message(s) that appear

      ODBC Error: [Actual][SQL Server] Unknown Host Machine Name.  [Actual][SQL Server]

      Configuration information

      Both the Server machine, the filemaker server and any FMP 12 or 13 Licences we have tried are all on the same local network

      Workaround

      Making a file in FM11 lets me set and define shadow tables in the relationship graph, I can then convert that fmp7 file to a fm12 file and the connection is still active, I can even define new shadow tables once converted and these work without error

        • 1. Re: ODBC Connection issues in Filemaker 12 and 13 Server and FMP
          TSGal

          Josh Hyman:

          Thank you for your post.

          Neither a Support Technician nor myself have encountered this issue.  After some discussion, we suggest making sure you have the correct MySQL driver installed - SQL Server Native Client 10.0 2009.100.1600.01 as per Knowledge Base Article #6420:

          http://help.filemaker.com/app/answers/detail/a_id/6420

          Why the DSN works with FileMaker Pro 11 and not FileMaker Pro 13 is a mystery.  I suggest recreating the DSN.

          Next, in FileMaker Pro 13, create a new database file and add a new External Data Source to the MySQL table.  If this works, then try again with your original file.

          Continue to keep me updated with any changes.

          TSGal
          FileMaker, Inc.

          • 2. Re: ODBC Connection issues in Filemaker 12 and 13 Server and FMP
            JoshHyman

            Hi TSGal

            Thanks for the information.

            The setup of the SQL server that we are working with is SQL Server 2008 R2 Service Pack 1 with the SQL Driver "SQL Server Native Client 10.0, Version 2009.100.2500.00, Date 17/06/2011"

            This appears to be a later version that what is suggested in the article, can I assume that the newer drivers will be supported or shall we look into rolling back the Driver to the version in the article above.

            Thanks for your help

             

            J

            • 3. Re: ODBC Connection issues in Filemaker 12 and 13 Server and FMP
              TSGal

              Josh Hyman:

              Since no issue has been reported with the minor update to the SQL Server driver, I recommend NOT rolling back to the version outlined in the Technical Specifications.  

              However, keep in mind that FileMaker Server 11 is 32-bit, while FileMaker Server 13 is 64-bit.

              In your converted file, are you connecting via FileMaker Pro (32-bit) or FileMaker Server (64-bit)?  Perhaps the FileMaker Pro 32-bit DSN is working for the files converted to FileMaker Pro 13.

              Along with the 32-bit DSN, also establish a 64-bit DSN with the same name.  If connected to FileMaker Server 13, it needs to be 64-bit.

              Continue to keep me updated with any progress.

              TSGal
              FileMaker, Inc.