paulked
09-02-2019, 09:34 PM
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
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