Hi,
I was asked how to setup a connection from an Access front end to a MySQL back end using SSH.
I can connect successfully to the back end using the odbc driver, now we were told that access to the back end server will be limited to fixed IPs (which most of our users don't have) or thru SSH tunneling.
I found a post on SSH and VBA http://unlimitedexcel.blogspot.com/2011/03/ssh-tunneling-port-forward-via-vba-wo.html but I can't get it to work.
So basically I'm trying to figure out how to set up a SSH secure connection to a MySQL back end.
p.s. If possible I would like to do as much of the process using VBA.
I was asked how to setup a connection from an Access front end to a MySQL back end using SSH.
I can connect successfully to the back end using the odbc driver, now we were told that access to the back end server will be limited to fixed IPs (which most of our users don't have) or thru SSH tunneling.
I found a post on SSH and VBA http://unlimitedexcel.blogspot.com/2011/03/ssh-tunneling-port-forward-via-vba-wo.html but I can't get it to work.
So basically I'm trying to figure out how to set up a SSH secure connection to a MySQL back end.
p.s. If possible I would like to do as much of the process using VBA.
