Discussion board where members can get started with Qlik Sense.
Dear Friends,i am trying to connect to my sql enterprise edition with credentials
Getting below error.
please help me.
Error Messagelease check the values for username,password,hostname and other properties. General error is discription.
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?
I have tested and able to connect to MySQL.i am trying to trouble shoot at server itself.
Thanks for prompt response.
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.
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.