Update FM data from mySQL

[WestCoaster]

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