I can't offer much help in this area, but will note that whether you are using FileMaker Server or FileMaker Server Advanced could make a significant difference in what you can do with ODBC.
My apologies. We are using FM 12 Server Advanced. Thanks for following up.
Any chance that anyone has some feedback on this? I have been sweating over this one, trying to figure out if there is any way to make Execute SQL script steps use my (FileMaker Server Advanced) server's ODBC connection, instead of the user's PCs ODBC. ...Just to reiterate, this functions as desired for the ESS-connected 'shadow tables', but not for the 'Execute SQL' script step... If anyone has any idea what I am doing wrong or how to fix this, I would forever be in your debt.
Thank you for your post.
FileMaker Pro will only see local ODBC sources. Only local access (same computer). Therefore, either each of your clients will need their own ODBC client driver, or set up a server side script to run at a specified interval against the remote table.
For more information, please see the FileMaker Pro 13 ODBC and JDBC Guide at:
Let me know if you need additional clarification.