MySQL Connectivity Issue

[#1]

Hello Everyone,

I want to retrieve Data from My SQL database,

I have downloaded and installed mysql-connector-odbc-5.2.4-winx64 driver

but not able to connect to the database.

Or please help me to get started with the conectivity if i am wrong.

Thanks and Regards

Priya

[manideep78]

Hello Priya,

Can you please tell me what error message you are getting or else provide me screen shot for that error???

[#3]

Please help me connect the Qlikview to Mysql in terms of connection string

[manideep78]

goto-->Edit Script

goto Data tab at bottom-->choose OLEDB for database option-->Click Connect button-->Select MySql provider-->Provide credentials and select database name and test connection-->

If it is successful click ok.

Note:If your database is 32 bit. check force 32 bit option in data tab of script editor.

[#5]

Priya,

Use the Microsoft Oledb provider for SQL Server by selecting OLEDB and the click connect on the bottom of the edit script.Then provide your database details.