Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

3 Replies
p_verkooijen
Partner - Specialist
Partner - Specialist

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
Author

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
Partner - Specialist
Partner - Specialist

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