Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Error with MySQL connection

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

Tags (1)
3 Replies
p_verkooijen
Valued Contributor

Re: Error with MySQL connection

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

Not applicable

Re: Error with MySQL connection

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,

LuisCaptura.JPG

p_verkooijen
Valued Contributor

Re: Error with MySQL connection

Hi lgalaz‌,

First create a dsn in Windows

CreateDSN.png

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

use the dsnname as Data source

CreateOLEDB.png