Problem with Mysql provider / qlikview

[#1]

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?

[Miguel_Angel_Baeyens]

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

[jjfabian]

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.

[Miguel_Angel_Baeyens]

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

[#5]

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

Also I have had a hard time finding the ODBC drivers

[jjfabian]

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

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

[#7]

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?

[jjfabian]

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.

[#9]

Thanks Jakob

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

[jjfabian]

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