MySQL problem with BODS 3.2

[Former Member]

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

[Former Member · Accepted solution]

Hi,

There are some known issues with some particuar versions of  mysql driver.

Can you confirm first the exact version of DS, Mysql client, Mysql odbc driver and Mysql server?

Thanks

Nawfal

[Former Member · Accepted solution]

Hi Nawfal,

Of course:

I am using:

DS 12.2.0.0

MySQL 5.0.45 (client and server)

MySQL ODBC 3.51.30 Win 32

[Former Member · Accepted solution]

Hi Molanus,

For the DS version and MySQL server that you have I would recommend that you use specifically one of these MySQL ODBC Connector 3.51.23, 3.51.24 or 3.51.25 since these are the drivers versions tested as per the PAR.

Let me know if you can if this helps

[Former Member · Accepted solution]

Hi Nawfal,

Great, this worked.

Thanks a lot.