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

    Is remote SQL access possible thru SSH?

    kentech

      Title

      Is remote SQL access possible thru SSH?

      Post

      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.