Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
rajendra1918
Not applicable

Error while connecting to MySQLenterprise Edition

Dear Friends,i am trying to connect to my sql enterprise edition with credentials

Getting below error.

please help me.

Error MessageSmiley Tonguelease check the values for username,password,hostname and other properties. General error is discription.

Regards,

Rajendra

4 Replies
JustinDallas
Not applicable

Re: Error while connecting to MySQLenterprise Edition

That's a very overly broad and useless error.  But you would have to troubleshoot, here is what I would try in no particular order.

1 .Can you connect to the server with MySQL Workbench using your credentials?

2. Can you ping the server?

3. Is the MySQL service running?

rajendra1918
Not applicable

Re: Error while connecting to MySQLenterprise Edition

Hi

I have tested and able to connect to MySQL.i am trying to trouble shoot at server itself.

Thanks for prompt response.

Regards,

Rajendra

balabhaskarqlik
Not applicable

Re: Error while connecting to MySQLenterprise Edition

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.

Later, From Qlik Sense you can access to MySql with a specific user credentials. You need to check ON THE DATABASE this user has the reading rights.

rajendra1918
Not applicable

Re: Error while connecting to MySQLenterprise Edition

Ok Thank you Bhaskar.

I have already installed MYSQL ODBC 3.1 and this is working fine. But i am trying to use mysql enterprise edition to connect the same.