2

I have been trying to create an SSH tunnel in order to connect a microsoft access frontend to a mysql database on my cloudways server. I have successfully connected to it and tested the mysql connection through putty, however it does not appear to let me connect to the DB on the ODBC with Microsoft Access. Not sure why it is not accepting the ip/port as local host.

Moyed Ansari
  • 8,436
  • 2
  • 36
  • 57
gxrobb
  • 45
  • 1
  • 5
  • Can you create an ODBC "System DSN" that connects to the MySQL database, then try using that DSN to define an ODBC linked table in Access? – Gord Thompson Dec 08 '16 at 23:46

0 Answers0