Are you using FileMaker Pro 12 32-bit or 64-bit You need to install same ODBC-driver as your installed FileMaker Pro.
I would recommend you to update to FileMaker Pro 15 where the driver have been updated
1 of 1 people found this helpful
Check extended privileges "fmxdbc" for the account used to connect.
I'm using FMP v14 and the 64 bit ODBC driver.
FMP v15 is going to have to wait for a bit.
Did you install the right driver for FMP14? Are you running the latest version of FMP14?
Dang, nice going, I'd better mark that down somewhere.
( File : Manage : Security : Extended Privileges : fmxdbc : New : etc )
You might also have to enable Sharing ( File : Sharing : Enable ODBC/JDBC )