Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

MySQL ODBC Driver not in list

HI there.

I'm starting to use QV, and I'm having an issue trying to connect a MySQL database.

When i go to file -> Edit Script in the QV menu and try to create an ODBC Connection, I can't see the MySQL ODBC driver listed.

I have the driver installed, actually i intalled 4 diferent versions (5.1 for 32 and 64 bits and 3.51 for 32 and 64 bits) and none of them are being displayed on the list.

My database is running on the local machine.

Can anybody help me out?

Tnx,

Raphael.

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens
Not applicable

Re: MySQL ODBC Driver not in list

Hello Raphael,

Are you using the latest version of QlikView (10 SR3 build 9061)? Have you created those ODBCs in Windows first? If you didn't, go to the start button, Control Panel, Administrative Tools, Data sources and crete one pointing to that database.

Search you hard disk for "syswow64\odbcad32.exe" and run it to see the 32 version of the drivers, should you have used them to create the ODBC.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

4 Replies
Miguel_Angel_Baeyens
Not applicable

Re: MySQL ODBC Driver not in list

Hello Raphael,

Are you using the latest version of QlikView (10 SR3 build 9061)? Have you created those ODBCs in Windows first? If you didn't, go to the start button, Control Panel, Administrative Tools, Data sources and crete one pointing to that database.

Search you hard disk for "syswow64\odbcad32.exe" and run it to see the 32 version of the drivers, should you have used them to create the ODBC.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable

MySQL ODBC Driver not in list

Thank you Miguel!

That worked out. I had to create the connection to the database in the Data Sources.

Not applicable

Re: MySQL ODBC Driver not in list

Thanks lot.

Not applicable

Re: MySQL ODBC Driver not in list

Thanks Miguel