Install an ODBC Driver. Add the DSN data source to the FileMaker Pro database. Add the table(s) to the relationship graph. Each of these steps is explained in detail below. Installing the MySQL ODBC Driver for Mac OS X. There are a number of MySQL ODBC drivers available for Mac OS X, many of which have simple package installers.
Date: October 27, 2005 12:31PM
- Independent Open DataBase Connectivity for Linux, MacOS X and Unix systems.
- MySQL Connector/J was developed as a tool to help the developers working with Java in order to create applets and tools that interact with MySQL. MySQL Connector/J provides a full-featured JDBC driver that comes with complete support for the MySQL capabilities. On top of that, the driver comes.
- Independent Open DataBase Connectivity for Linux, MacOS X and Unix systems.
I'm using MyODBC 3.51.12 that I downloaded today, and installed on a Mac Server (OSX Server 10.4.2)
MyODBC appeared to install fine, but I don't get any ODBC drivers listed in the ODBC Administration area.. I noticed others on Windows having the same problem, but the registry key fix won't translate to a Mac - does anybody know how to get this going? I tried to manually add the driver using the /usr/lib/libmyodbc3.dylib file as the library, but this returns an error in the form of:
Driver Manager: 03.52.0001.0928
Enter ODBC connect string (? shows list): dsn=Test
1: SQLDriverConnect = [iODBC][Driver Manager]dlopen(/usr/lib/libmyodbc3.dylib, 6): Library not loaded: /usr/lib/libltdl.3.dylib
Referenced from: /usr/lib/libmyodbc3.dylib
Reason: image not found (0) SQLSTATE=00000
2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be loaded (0) SQLSTATE=IM003
This is using the /usr/bin/iodbctest program to test the DSN I had created.
There isn't much instruction to installing this, as it's just a case of mounting the downloaded image and letting it install - so I'm not sure if or where I have gone wrong.
Thanks in advance,
Edited 1 time(s). Last edit at 10/27/2005 12:32PM by Phil Barbier.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
Date: October 27, 2005 12:31PM
- Independent Open DataBase Connectivity for Linux, MacOS X and Unix systems.
- MySQL Connector/J was developed as a tool to help the developers working with Java in order to create applets and tools that interact with MySQL. MySQL Connector/J provides a full-featured JDBC driver that comes with complete support for the MySQL capabilities. On top of that, the driver comes.
- Independent Open DataBase Connectivity for Linux, MacOS X and Unix systems.
I'm using MyODBC 3.51.12 that I downloaded today, and installed on a Mac Server (OSX Server 10.4.2)
MyODBC appeared to install fine, but I don't get any ODBC drivers listed in the ODBC Administration area.. I noticed others on Windows having the same problem, but the registry key fix won't translate to a Mac - does anybody know how to get this going? I tried to manually add the driver using the /usr/lib/libmyodbc3.dylib file as the library, but this returns an error in the form of:
Driver Manager: 03.52.0001.0928
Enter ODBC connect string (? shows list): dsn=Test
1: SQLDriverConnect = [iODBC][Driver Manager]dlopen(/usr/lib/libmyodbc3.dylib, 6): Library not loaded: /usr/lib/libltdl.3.dylib
Referenced from: /usr/lib/libmyodbc3.dylib
Reason: image not found (0) SQLSTATE=00000
2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be loaded (0) SQLSTATE=IM003
This is using the /usr/bin/iodbctest program to test the DSN I had created.
There isn't much instruction to installing this, as it's just a case of mounting the downloaded image and letting it install - so I'm not sure if or where I have gone wrong.
Thanks in advance,
Edited 1 time(s). Last edit at 10/27/2005 12:32PM by Phil Barbier.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
| Click here to return to the 'How to access MySQL data in Filemaker via ODBC' hint |
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.
Guitar software for macbook. 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.
Postgresql Odbc Driver Mac
drivers ship with a fully-functioning 30-day trial licensewhich 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.
Mysql Odbc Driver 3.51 Download
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 | # ]
Except that the driver only allows the first three rows to be imported until you register.
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/
Odbc Sql 13 Driver Download
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
