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!)

VBAEx29.jpg

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:

VBAEx30.jpg

Any ideas?

Thanks