2 Replies Latest reply on Oct 30, 2009 4:16 AM by MikeyG79

    Is remote SQL access possible thru SSH?



      Is remote SQL access possible thru SSH?


      I have the possible need to connect a local FM database, on an as-neededbasis, to a remotely-hosted MySQL database thru SSH.


      I have tested a similar database without SSH using the Actual Technologies driver and ODBC, and it works perfectly for my purposes -- except this was a proof-of-concept demonstration NOT using SSH. The hosting company of the SQL database that I will be asked to access IS protected by SSH, and so I assume that I have to first establish an SSH 'tunnel." But can Filemaker work with this using ODBC?


      If anyone can point me to some documentation on this (Filemaker-specific), I would be grateful. Or if you know of a method that works, please offer a few tips. This is with FM 10 and Mac OS 10.6.1 (Snow Leopard).


      If SSH is a show-stopper for Filemaker Pro access to remote SQL databases, I need to know so I can suggest the choice of an non-SSH-protected hosting service.