Hi all,
I am trying to connect BODS 3.2 running on a x64 machine (Win 2008 R2) to a mySQL database. For this purpose I have installed the 32bit ODBC connector, and the connection to the repository (also mySQL) is running ok.
I can even run an imported job.
But when I create a datastore and try to connect to the mySQL database, it takes forever (well, I gave up after half an hour) to create a list of tables if I use root as the login.
When I use a more restricted user I get a list of tables very quickly, but: the tables are each shown five times, and they are preceded by '%.', leading to an error when I try to import them.
I have never seen this before. Anyone know what to do about it?
Thanks