Trying to connect to MySQL from Excel VBA

[Jeff Wiseman]

I am trying unsuccessfully to connect to the sample database sakila in my new MySQL installation from Excel VBA with the following code:

Sub ConnectToMySQL()
Dim sakilaConn As ADODB.Connection
Set sakilaConn = New ADODB.Connection
sakilaConn.ConnectionString = "DRIVER={MySQL ODBC 5.3 ANSI Driver};" & _
"SERVER=localhost;" & _
"DATABASE=sakila;" & _
"UID=myUserID;" & _
"PWD=myPassword" & _
"OPTION=3"
sakilaConn.Open
sakilaConn.Close

It fails at the Open with:

Run-time error '-2147467259 (80004005)':
[Microsoft][ODCB Driver Manager] Data source name not found and no default driver specified

Note: MySQL for Excel is installed and connecting through it succeeds, no problem.

Running:
Windows 10 64-bit
Excel 2013 32-bit
MySQL 5.7.9 (64-bit?)

Probably shouldn't be a factor, but myPassword does contain special chars.

Thanks for any advice you can provide.