Hi Some help on this issue would be much appreciated as I am banging my head against a brick wall and I must be missing something

First of all I am running XAMPP as my server with MySQL version 5.6.2

•Server: 127.0.0.1 via TCP/IP
•Server type: MySQL
•Server version: 5.6.20 - MySQL Community Server (GPL)
•Protocol version: 10
•User: root@localhost
• Server charset: UTF-8 Unicode (utf8)

The database is running as this is grabbed from phpMyAdmin

I have installed the latest Oracle ODBC Drivers for MySQL to my system. I am running windows 8.1 on a 64bit system (I am aware there are some issues for 64 bit systems and I have followed the guidance for that from this URL.

https://www.connectionstrings.com/my...ctor-odbc-5-2/

My connection string is as follows:-

    Set MyConnection = New ADODB.Connection

    MyConnection.ConnectionString = "Provider=MSDASQL; Driver={MySQL ODBC 5.2 UNICODE Driver}; Server=127.0.0.1; Port=3306; Database=compliance; User=compliance; Password=blah; Option=3"

    MyConnection.Open

I can connect to this database in the Excel page by connecting a data source so I know the database is reachable via excel and van view the tables.

I am running office 2013. Therefore Excel 2013

What am I missing I am constantly getting this error. Sorry its a pic but can't grab the text

Capture.JPG

Any help much appreciated

Thanks