script for import ODBC from mysql
Does anyone know the best way to import data from a remote mysql database to a local computer with server advanced that serves a small office.
When I bought server 9 advanced I thoguht it would be easy to time a script to get data through ODBC from a remote mysql database but the many many support calls I made said "no".
Any idea how to get the data in a timed manor - say every hour. The server gets requests from many web site "quote pages"
Also (this might be questions #2 but) can you open a field in filemaker to sync / change data directly with a remote mysql database? For instance to change a price in a pricing cataloge?
Thanks, steelbut (larry)