September 29, 200718 yr This is my first attempt to connect to a MySQL served database using FileMaker 9 demo: I have installed MySQL on OSX.4.10, plus Actual Technologies driver, and Navicat demos. The sever is running. I have created a database a using Navicat ODBC Administrator is configured for User DSN using driver: Actual Open Source Databases, type: MySQL, connecting to server: localhost, the database created under Navicat is listed in the ODBC Databases to connect to In FileMaker, Manage External Data Source, new, select ODBC, specify >> Select ODBC Data Source pop window has nothing listed to select what might I try to correct this?
September 30, 200718 yr Author resolved: set System DSN in ODBC Administrator; FileMaker now sees the MySQL tables. Using User DSN doesn't work.
October 1, 200718 yr You are correct - FMP 9 External SQL Sources (ESS) only supports System DSN's. User DSN's will not appear in the list. I don't know all the reasoning behind this decision, but I do know that this behavior is intentional. Jonathan Monroe Actual Technologies - ODBC for Mac OS X www.actualtechnologies.com
Create an account or sign in to comment