(optional) create table filemaker and user with rights for db on localhost

mysql> create database 'filemaker';
mysql> grant all on filemaker.* to 'filemaker'@'localhost' identified by 'filemakerpass';

1. download and install bitvise ssh client (stays in tray on reboot and keeps ssh open)

–> 01-configure login data

–> 02-setup-client-to-server-portforwarding

–> 03-voila = testing with heidisql shows sql server ist accessible via localhost (yes, its the remote one)

• download the right driver

• In Windows go to ContolPanel\Administrative Tools and Click on Data Sources
• IN German Windows the path is 'Systemsteuerung\Alle Systemsteuerungselemente\Verwaltung'
• then Data Sources ODBX (Datenquellen ODBC)
• start it and type the server data in a new mysql thingy in user-dsn AND system-dsn

• [Filemaker]>File>Sharing>enable ODBC/JDBC

• with opened filemaker db: File>Manage>Security>Privilege Sets
• Tab:Extended privileges > double click on Access via ODBC/JDBC (fmxdbc) so this has rights = granted
• then: File>Manage>Externel Data Sources
• add new
• Type: ODBC
• choose DSN

[1] http://www.milanm.com/?p=491