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

How to access MySQL data in Filemaker via ODBC Apps
In order to import data from a MySQL database into FileMaker 6 via ODBC, do not install the DataDirect ODBC driver that comes with FileMaker. Instead, download the OpenLink one.

If you decided to install the DataDirect driver (which only has a driver to access PlainText files, but not MySQL), you will have to uninstall it in order to be able to access the OpenLink one. I have spent a whole morning trying to figure this out until I read the FAQs file in OpenLink's homepage.

    •    
  • Currently 1.00 / 5
  • 1
  • 2
  • 3
  • 4
  • 5
  (3 votes cast)
 
[21,159 views]  

How to access MySQL data in Filemaker via ODBC | 8 comments | Create New Account
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: inmanjm on Feb 10, '04 02:25:44PM

You are my HERO!
I have been trying to do this for a while. I had done the OpenLink ODBC install and was going bonkers trying to figure it out. Guess I was always looking in the wrong spot! Many thanks.



[ Reply to This | # ]
How to access MySQL data in Filemaker via ODBC
Authored by: amontague on Feb 10, '04 06:31:06PM

Were you able to update your MySQL database directly from FM Pro?

Using MS Access and an ODBC driver, I can update a MySQL database using Access' standard graphical interface. I can't seem to do this with FM Pro.



[ Reply to This | # ]
How to access MySQL data in Filemaker via ODBC
Authored by: bluehz on Feb 11, '04 08:58:34AM
You might want to indicate that these are not free... unless I am missing something...
drivers ship with a fully-functioning 30-day trial license
which the name "opensource" doesn't really reflect. I guess I am used to "opensoure" as without cost. This also requires an email registration to receive the file.

[ Reply to This | # ]
How to access MySQL data in Filemaker via ODBC
Authored by: pweil on Feb 24, '04 02:06:44PM
I have been able to both import and update remote MySQL data with Filemaker 6 and the OpenLink driver (using a 30-day demo). That's the good news -- it does indeed perform queries and retirn (import) the results. The bad news (from my point of view) is that, aside from the fact that the driver is not free (as someone else pointed out), the FM interface for this is pretty clunky, even if you script the query (3 or 4 dialog boxes each time to ok the data source, user login, and query). And you can't create forms that will allow you to work easily with the data on the server. It has to be imported into a FileMaker file first. We're working on porting Rekall over to OS X; if it works, it will be a *much* better solution than FM.

[ Reply to This | # ]
How to access MySQL data in Filemaker via ODBC
Authored by: monroej on Aug 11, '04 01:05:43PM
Actual Technologies also makes a commercial ODBC driver for MySQL for Mac OS X that works with FileMaker Pro 6 or later. It has an installer, a DSN setup assistant, on-line help, and connection diagnostic tool.

Instructions for configuring FMP to work with the driver can be found in the FAQ. A free, non-expiring evaluation version is available for download (no registration required). The price for the full version is $30.

Jonathan Monroe
Actual Technologies - ODBC for OS X


[
Reply to This | # ]
How to access MySQL data in Filemaker via ODBC
Authored by: glenstorm on Jan 11, '05 01:32:38AM
. A free, non-expiring evaluation version is available for download (no registration required).

Except that the driver only allows the first three rows to be imported until you register.

[ Reply to This | # ]

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 | # ]