Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm just trying to connect a Mysql Database to Qlikview but I have not been able to make it,
I have read some threads about it but no luck:(
I must say that this database is currently connected to my excel without any problem. I downloaded the corresponding ODBC connectors
About Qlikview, I went into script editor:
I select 'ODBC DataBase' and then to 'Connect',
This window appear to me, with some data sources, among them 'josue' , that is a connection that I created when trying to connect to Excel,
But when trying to connect, I got the following message error:
Can anybody help me?
Thanks a lot, people!!
You will first have to install an ODBC driver for the MySQL database. Then you need to use the ODBC admin tool to create an odbc datasource for the MySQL database you want to connect to. Perhaps this article helps: Step-by-step guide on how to set up DSN in ODBC Data Source Administrator on Windows.
Or this one if you're using a 64-bit system: Install and Create MySQL ODBC Connector on Windows 7 64 bit | Plain Tutorials
1 Create your odbc connection from your control panel in Windows (the name is for example MyODBC)
2 use in the script: CONNECT TO MyODBC;
let me know