Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Click here to return to the 'How to access MySQL data in Filemaker via ODBC' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
How to access MySQL data in Filemaker via ODBC
Authored by: sillyxone on Oct 12, '04 04:07:44PM

Hi, I think the mySQL 4.0.21from ServerLogistics is working originally (for OS X 10.3), but I just post it here in case someone is getting stuck because I had to do some tricks to it.

- Download Complete MySQL 4.0.21 from Install mySQL and ODBC package.

- You can use ODBC Administrator included with OSX to add driver/dsn, but you will have to edit odbc.ini manually anyway. ODBC Admin doesn't change it correctly.

- if it's a user dsn, then edit file: /Users/username/Library/ODBC/odbc.ini; if you use system dsn, then the file odbc.ini is in /Library/ODBC/

- Refer to odbc.ini guideline from:

- Test your odbc driver using odbctest command in Terminal, make sure it works.

- If you can connect to your dsn using odbctest, but cannot see it in FileMaker or Excel, move the file "ODBC Driver Manager" out of the folder /Library/CFMSupport. (This took me a week to figure out until I try on a clean machine. This file normally is not there.)

Here is my odbc.ini:
[ODBC Data Sources]
testmyodbc = MyODBC Driver

Driver = /Library/MyODBC/lib/libmyodbc3-3.51.06.bundle
Description = Test MyODBC driver
Database = test

Trace = 0
TraceAutoStop = 0
TraceFile =
TraceLibrary =

Command to test in terminal:
odbctest --> ? --> dsn=testmyodbc

[ Reply to This | # ]