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: adi on Sep 07, '04 08:14:15AM

Well it works on windows. It should work on Mac OS X too. I havent tried this but
there is a MyODBC driver section for Mac OS X :
http://dev.mysql.com/downloads/connector/odbc/3.51.html
and some instructions :
http://www.geocities.com/rotedream/



[ Reply to This | # ]
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 serverlogistics.com. 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:
http://www.iodbc.org/index.php?page=docs/faq#iodbc333712082

- 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

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

[ODBC]
Trace = 0
TraceAutoStop = 0
TraceFile =
TraceLibrary =
--------------------------------------

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





[ Reply to This | # ]