I have a Access 2k3 database that uses an ODBC Connection to a MYSQL database, Thanks to some experts at experts-exchange that works great. Unfortunately, in order to access the MySQL server I have to open a SSH connection via Putty.exe. Due to timeout issues, just leaving the connection open is not good enough. I am looking for a command line code or Shell command that I can use thru VBA or bat file to open the connection, pass the user name and password.
I am trying to setup a scheduled task that will run in the middle of the night and this is my only obstacle.