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.