Connecting VBA with MySQL 5.7
Posted by: Richard Case
Date: November 04, 2017 11:26AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Connecting VBA with MySQL 5.7
November 04, 2017 11:26AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.