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