Skip to Content
0
Former Member
Nov 09, 2012 at 11:46 AM

MySQL problem with BODS 3.2

38 Views

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