ODBC data for MySQL connects and retrieves tables, but displays no data.

[#1]

Hi.

I'm trying to load data from a remote MySQL Community Edition database, but I'm experiencing problems. It connects correctly, allowing to select the database and displaying all tables, but no data is displayed. What could be wrong? I'm attaching a screenshot of what happens.

Regards,

Fábio

[#2]

Same things to me.

MySql ODBC connector works fine, when I tested connection to DB.

[#3]

I have exactly the same problem, is there someone with a solution?

Thanks

Regards

[Michael_Tarallo]

Hello Guys -

This is a known issue and should be fixed in the next service release. In the mean time you can use script to get the data, See solutions outlined here: Re: Why Qsense cannot load data from a Mysql table

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

[Anonymous]

Try to use new version of MySQL ODBC driver. We tested it with our MySQL database and it worked fine.