I would try using the MySQL ODBC 3.51 driver instead. That's what I've always used and I'm on my 5th version of MariaDB.
Mike Copeland
Chris Davis wrote:
It is something to do with the user, as I have now created a user called "tester", changed my connection string and when I try and add the table stock to my remote view I get the error table tester.stock doesn't exist, does that help?