Trying to connect to MariaDB (mysql)

Hi,

I am trying to connect to my mysql database but I keep getting automation error 80004005.

I have tried to attach a picture of my code and picture of odbc connection so that you could see that the driver has been installed.

Do you have any sugguestions.

I believe it may be something with the driver part of the connstr but I am not really sure.

sqlconn.JPG

thanks in advance

Try changing the brackets around the MySQL ODBC 5.3 ANSI Driver to be Curly ones...
eg {MySQL ODBC 5.3 ANSI Driver}