Connecting to phpMyAdmin SQL DB through SSH

[paulked]

We have changed our ISP and they only allow access to the DB's through SSH.

I have tunnelled using PuTTY and successfully connected to the site (I think!)

24925

I trying to connect (64bit Excel) using:



Sub ConnectFringe()
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
cn.Open "Provider=MSDASQL;DRIVER={MySQL ODBC 5.3 Unicode Driver}" _
& ";SERVER=localhost" _
& ";PORT=3356" _
& ";DATABASE=fringell_DbgTfg0O" _
& ";UID=****" _
& ";PWD=****;OPTION=3"
End Sub


but I'm getting error Data source not found and no default driver specified

References I am using are:

24926

Any ideas?

Thanks