How to create a linked server to MySQL with a SSH tunnel


  • I trying to create a linked server in SQL 2005 to an external MySQL database . This requires an SSH tunnel. I've saved  a Puttygen session with correct parameters which seems to work.  My problem is that the next stage, how to set up an ODBC data source  isn't clear.  I can create a .bat with the a plink command which opens the tunnel but this may not be way to do it. I'm trying to use an ODBC 5.1 driver. 

    Any guidance ?

    Monday, May 21, 2012 11:38 AM