Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
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
Partner
Partner

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

Partner
Partner

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