no ODBC Data source

[Cortical]

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?

[Cortical]

resolved:

set System DSN in ODBC Administrator; FileMaker now sees the MySQL tables. Using User DSN doesn't work.

[Jonathan Monroe]

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