topic MySQL Connectivity Issue in QlikView

MySQL Connectivity Issue

Tue, 26 Mar 2013 11:32:24 GMT

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

Re: MySQL Connectivity Issue

manideep78 — Tue, 26 Mar 2013 11:53:44 GMT

Hello Priya,

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

Re: MySQL Connectivity Issue

Tue, 26 Mar 2013 12:04:57 GMT

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

Re: MySQL Connectivity Issue

manideep78 — Tue, 26 Mar 2013 12:11:00 GMT

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.

Re: MySQL Connectivity Issue

Tue, 26 Mar 2013 12:12:58 GMT

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.