topic OBDC Issue, when trying to connect to mysql in QlikView

OBDC Issue, when trying to connect to mysql

Wed, 04 Jul 2012 09:13:39 GMT

I'm trying to connect to my MYSQL database through ODBC, but when I try to connect - I get this message

When I close the message - Im still directed to the select window, but Im not able to see any other info that the tables in the database:

Can somebody help me - I have tried on XP and Windows 7 and it's the same issue?

Re: OBDC Issue, when trying to connect to mysql

Wed, 04 Jul 2012 12:50:52 GMT

No one who is able to help?

Re: OBDC Issue, when trying to connect to mysql

Wed, 04 Jul 2012 12:55:26 GMT

check Force 32 Bit option and try

Re: OBDC Issue, when trying to connect to mysql

Wed, 04 Jul 2012 12:56:09 GMT

I have done that, but it's the same issue

Re: OBDC Issue, when trying to connect to mysql

jjfabian — Fri, 06 Jul 2012 13:30:58 GMT

Hi there,

so I finally mynaged to recreate your problem. On my machine it seems to be occuring when you attempt to access an empty table within the MySQL (in this database I have 6 tables, one of them which is currently empty. I only get the problem when I try to select that one).

So, the question is, do you have any empty tables in your MySQL?

If that is the case, then maybe this is a bug of some sort

Best regards, Jakob

Edit: If this is indeed caused by a specific table, have you tried loading the data by manually writing LOAD *; SQL SELECT * from yourtable

Re: OBDC Issue, when trying to connect to mysql

jjfabian — Fri, 06 Jul 2012 13:52:03 GMT

I've made another observation here: now, the table is not empty anymore, but contains non-standard characters. Seems to cause the crash. I'll keep you posted as I discover more.

Re: OBDC Issue, when trying to connect to mysql

Mon, 09 Jul 2012 05:49:31 GMT

Even I am facing the same issue ..

Regards,

Mandar

Re: OBDC Issue, when trying to connect to mysql

jjfabian — Mon, 09 Jul 2012 08:03:58 GMT

Hi everyone,

found a solution that works for me.

Previously, I was using the 5.1.11 MySQL ODBC drivers.

Switched to the 5.1.9 Version of the driver, now it works just fine for me.

Regards, Jakob

Re: OBDC Issue, when trying to connect to mysql

Mon, 09 Jul 2012 08:08:51 GMT

I can´t find that driver - do you have a link?

Re: OBDC Issue, when trying to connect to mysql

jjfabian — Mon, 09 Jul 2012 09:13:20 GMT

I can't find the link either. I pulled it from my company's software drive.

I've attached the file, so that you can test if it solves your problem.

I'll supply a direct download link if I can find one.

Jakob

Re: OBDC Issue, when trying to connect to mysql

jjfabian — Mon, 09 Jul 2012 09:15:48 GMT

Hi again,

all ODBC driver versions can be found on this page.

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

Re: OBDC Issue, when trying to connect to mysql

Mon, 09 Jul 2012 09:35:35 GMT

I uninstalled the 5.1.11 and installed 5.1.09 - but I have a problem.

I am not able to choose this driver under windows control panel ?

I tried reinstalling the 5.1.11 and it comes right up, so I don't understand how to solve this (im on windows 7)

Re: OBDC Issue, when trying to connect to mysql

jjfabian — Mon, 09 Jul 2012 09:45:11 GMT

Looks like you installed 5.0.9 from your screenshot.

5.1.9 works flawlessly in Win 7 for me.

Re: OBDC Issue, when trying to connect to mysql

Mon, 09 Jul 2012 10:29:58 GMT

5.1.9 works like a charm! thank you!

Re: OBDC Issue, when trying to connect to mysql

Mon, 09 Jul 2012 11:28:16 GMT

Thank you very much Jakob .. 5.1.9 is workin fine !!

Cheers,

Mandar