Problems connecting to MySQL Database

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:-

Please Login or Register  to view this content.

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

The properties are exactly as I have them. I have temporarily fixed this by just setting the connection to my DSN which I set up in admin tools

Please Login or Register  to view this content.

This is not the ideal solution as I would like it to be stand alone (I know they had to have the drivers, but don't want top be messing with admin tools to set up a DSN.