Error with MySQL connection

[#1]

Hi, I connect QlikSense 3.0 with MySQL server with ODBC. The conector work fine, I can read tables but no data is loaded when a table is selected.

Any ideas?

Best

Luis

[p_verkooijen]

Hi lgalaz‌,

I had the same issues when I used a ODBC dns connection. (Worked fine using QlikView though)

Try to Create New Connection --> OLE DB --> Microsoft OLE DB Provider for ODBC Drivers

[#3]

Hi Paul, thanks for your reply, but when use the OLE DB provider for ODBC, the connection fail. This connection must work with MySQL?

Best,

Luis

[p_verkooijen]

Hi lgalaz‌,

First create a dsn in Windows

Then Create New Connection --> OLE DB --> Microsoft OLE DB Provider for ODBC Drivers

use the dsnname as Data source