topic Re: Problem with Mysql provider / qlikview in QlikView

Problem with Mysql provider / qlikview

Mon, 25 Jun 2012 10:25:51 GMT

I'm trying to connect to my new mysql BI server with qlikview, but I have not been succesfull.

I want to find out what I'm doing wrong...

it´s very strange, because each time I try to test the connection in the select windows it's either succesfull or I see the message

If I try to pick the intial catalog it will also either let me pick or I get this message

The succes / failure rate are almost 50 / 50 and if I click okay I will get this window:

Can somebody tell me what's wrong?

Re: Problem with Mysql provider / qlikview

Miguel_Angel_Baeyens — Mon, 25 Jun 2012 10:38:04 GMT

Hi,

Are you using the same version of ODBC than the server is running? Does that happen either if you have Force 32 bit checked and unchecked?

Hope that helps.

Miguel

Re: Problem with Mysql provider / qlikview

jjfabian — Mon, 25 Jun 2012 10:41:55 GMT

Hi there,

I would recommend that you try connecting to your MySQL thorugh ODBC. If your MySQL database is setup correctly under Windows it should connect with no problems.

Re: Problem with Mysql provider / qlikview

Miguel_Angel_Baeyens — Mon, 25 Jun 2012 10:45:21 GMT

Hi Jakob,

Yes, definitely. If using OLE DB when it's not supported natively, using what the DBM supports (and MySQL supports ODBC) is the smartest thing to do.

Thanks for noting!

Miguel

Re: Problem with Mysql provider / qlikview

Mon, 25 Jun 2012 11:25:07 GMT

But the server are not hosted locally - can I still use ODBC...

Also I have had a hard time finding the ODBC drivers

Re: Problem with Mysql provider / qlikview

jjfabian — Mon, 25 Jun 2012 11:39:18 GMT

Hi, to answer both of your questions ...I recently used these drivers on a remotely hosted MySQL 🙂

http://dev.mysql.com/downloads/connector/odbc/

Re: Problem with Mysql provider / qlikview

Mon, 25 Jun 2012 11:54:55 GMT

Hi Jakob,

I'll have to say i'm a newbie when it comes to qlikview 🙂

I downloaded and installed the connector, but when I open the ODBC window I can't chose mysql. Can you tell me how to hook everything up?

Re: Problem with Mysql provider / qlikview

jjfabian — Mon, 25 Jun 2012 12:00:44 GMT

Hi again,

it's no really a QlikView thing that your're missing, you will have to add your ODBC datasource in Windows. Looking at your screenshots I'm assuming you are running XP.

To open Data Sources (ODBC), click Start, click Control Panel, and then click Performance and Maintenance. Click Administrative Tools, and then double-click Data Sources (ODBC).

There you can add your ODBC connection to your database.

Click Add and select MySQL ODBC Driver 5.1 (this may vary depending on the version that you installed)

After that, a window should open up where you can enter your MySQL Servers credentials and name your connection.

This connection then becomes available for you to use in QlikView.

Re: Problem with Mysql provider / qlikview

Mon, 25 Jun 2012 12:44:25 GMT

Thanks Jakob

However when I try to connect in Qlikview, it comes with this error message

Re: Problem with Mysql provider / qlikview

jjfabian — Mon, 25 Jun 2012 12:51:02 GMT

Ok, that's unfortunate ...

Maybe Miguel has an idea what this could be about. Did you try playing around with your 32-Bit Settings like he suggested earlier?

Also, just out of curiosity, were you able to succesfully test your connection to your MySQL datasource when setting it up Windows how I explained it earlier.

Good luck with this,

Jakob

Re: Problem with Mysql provider / qlikview

Wed, 31 Oct 2012 10:51:33 GMT

Hi,

I'm having the same problem too!

I have started a new discussion for the same: http://community.qlik.com/thread/65096

Regards,

Natasha