1 Reply Latest reply on Jan 4, 2011 10:18 AM by TSGal

    FMPro 11 Connecting to an ODBC Data Source on Windows 7

    RonSteiner

      Summary

      FMPro 11 Connecting to an ODBC Data Source on Windows 7

      Product

      FileMaker Pro

      Version

      11.0v2

      Operating system version

      Windows 7 Pro 64-bit

      Description of the issue

      I am running FMPro 11.0v2 on Windows 7 (64bit). I have data in a MySQL database that I'd like to link to with FM Pro.  I have set up the MySQL ODBC DSN using the 32 bit drivers.

      When I do an import the 'Select ODBC Data Source' list is populated as I'd expect with all the local ODBC DSNs and I can import data from the MySQL ODBC DSN I set up with no difficulty.

      But if I try to link to the data instead of import it (using File | Manage ... | External Data Sources | New... | Edit Data Source and selecting ODBC, then Specify ... button) no DSNs appear in the 'Select ODBC Data Source' list.

      What can I do to help debug this?

      Thanks

      Steps to reproduce the problem

      See description.

      Expected result

      I would expect to be able to link to an ODBC Data Source if I can import from it.

      Actual result

      No DSN's appear when I try to specify one for linking.

      Exact text of any error message(s) that appear

      No messages, just an empty 'Select ODBC Data Source' list.