Excel To MySql : MySql drivers failed to install

[mmmarks]

Hi Xcel gurus,

I have a workbook which connecting to Mysql and getting data (In Pivot) no issues.

Plan is to distribute this Workbook to my team so that they can able to see LIVE updates by Mysql.

Issue : while testing, I have given this workbook to one of my team mate, and he is unable to Refresh Pivot table and giving below error.

ODBC Driver Manager Data source name not found and no default driver specified.

Below error comes when Mysql drivers not configured in ODBC-Drivers ( In My system I do have but It's not possible to configure manually in every system so I'm looking for a code which automatically add MySQL Drivers in ODBC and code will execute.

Tried many possibilites.

Dim oConn As ADODB.Connection
Private Sub ConnectDB()
Set oConn = New ADODB.Connection
Dim str As String
str = "DRIVER={MySQL ODBC 5.3 Unicode Driver};" & _
                                            "SERVER=103.231.8.95;" & _
                                            "PORT=3306" & _
                                            "DATABASE=quality_db;" & _
                                            "UID=root;" & _
                                            "PWD=********;" & _
                                            "Option=3"
''' error '''
oConn.Open str
End Sub

Above code is not installing MySql Drivers

Any help will be highly appreciated.