Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Update FM data from mySQL

WestCoaster
in External Data Sources

Featured Replies

Hi all,

I am looking for a way to update data in FileMaker 6 Windows from a mySQL database via ODBC. The mySQL database is part of a web application. Each time a record in mySQL is edited also the corresponding record in FileMaker needs to be updated. The records would be updated via ODBC by an automated FileMaker client that is running on an untouched Win 2000 machine.

Because the database on the FileMaker side is rather complex there are 2 things that we cannot do: 1. Upgrade to FM 7, 2. solve the issue by just deleting the records in question from FileMaker and then reimport the newer version of the record from mySQL (this is not an option because there are a lot of auto generated values etc. on the FileMaker side that would be lost).

I didn't find any appropiate suggestions in the forum and I am completely stuck with this when trying to set it up. Has anyone any experience with that? I tried to install the DataDirect 32-bit SequeLink 5.4 driver but it wouldn't even let me choose which FileMaker database I'd like to talk to.

We have successfully set up an ODBC connection from FileMaker to mySQL which updates records in mySQL after they have been altered in FileMaker. Also we retrieve new mySQL records into FileMaker via ODBC + import. This setup works perfectly well and runs automated every few seconds.

For several reasons another way than linking via ODBC (e. g. flat file, XML) would not work for us.

If you have any ideas please let me know.

Greetings

Thomas

Create an account or sign in to comment

https://fmforums.com/topic/34242-update-fm-data-from-mysql/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.