FMPro 11 Connecting to an ODBC Data Source on Windows 7
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?
Steps to reproduce the problem
I would expect to be able to link to an ODBC Data Source if I can import from it.
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.