Connecting VBA with MySQL 5.7

[Richard Case]

I am trying to connect newly installed MySQL Community version to VBA in Excel 2016. I have tried:

Dim oConn As ADODB.Connection

Set oConn = New ADODB.Connection
Dim str As String
'I have tried all of these

'str = "DRIVER={MySQL ODBC 5 Driver};"
'str = "DRIVER={MySQL ODBC 5.7 Driver};"
'str = "DRIVER={MySQL ODBC 5.7-Log Driver};"
'str = "DRIVER={MySQL ODBC 5.7-log Driver};"
'str = "DRIVER={MySQL ODBC MySQL57};"

str = "DRIVER={MySQL ODBC MySQL Server 5.7 Driver};" & _
"SERVER=ALIEN;" & _
"PORT=3306;" & _
"DATABASE=World;" & _
"Uid=Rhcase;" & _
"Pwd=2174;" & _
"Option=3"
oConn.Open str

Nothing works and I have tried using Regedit to find the right version without success.