What MySQL database are you trying to connect to: enterprise or community?
With enterprise, you should create your connection using the driver shipped with Expressor; do not create an ODBC DSN, create a database connection by selecting the driver from the top dropdown in the wizard.
For community, you must obtain and install the ODBC driver, but once you do you can create a connection by selecting MySQL from the middle dropdown in the wizard. Again, do not create an ODBC DSN. Check the documentation for the proper version of the driver to install.
This screen appears when the connection to the database fails and indicates either that the driver is incorrect, that the connection details are incorrect, or that the database is not properly configured. Can you connect to the database using an ODBC client such as DBVisualizer or Toad?
Am using the community version, but somehow with QlikView itself its working but when using the QlikView Expressor it's not working as expected. I did download the driver and tried creating a connection but once again, failed.
So would you happen to know what am doing wrong here? Any suggestion?
P/S: Sorry for the late reply, was rushing a deadline.
You can download latest expressor software from Qlikview downloads site
and download training material from the below link.
Follow the instructions.
Hopefully it should solve your problem.
You must be careful which version of the MySQL Community Edition driver you use. With Expressor 3.12, you must use the 5.2.6 release of the driver; with older versions of Expressor use 5.1.8. Expressor is very specific about which driver can be used with a particular version. Are you sure you have the correct driver version?
When you say the driver works with QlikView but not with Expressor, does this indicate that you are using an ODBC DSN in your Expressor Connection artifact. With MySQL, you should create the Connection artifact by selecting MySQL from the dropdown menu associated with the middle radio button.