Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connecting to mysql database

Hi guys.

I want to start with Qlik sense desktop to test its features. My data source is mysql running on centos 7 linux server. In order to connect to this database, I selected MySql Enterprice Edition in the first step pf the "Add data" process. I filled out the form with correct info (I checked host, username and password) to connect to database. But it gives error message with description: general error! How can I gain more info about the error to see the connection problem? How can I resolve the problem? Any help will be appreciated.

2 Replies
petter
Partner - Champion III
Partner - Champion III

Have you tested the connection from the ODBC Manager in Windows and succesfully connected there?

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

You can install the MySQL odbc connector and then  you can create a system (or user) DSN connection in windows ODBC manager. Just make sure to configure correctly either 32 o 64 bit depending on your needs,

regards