QlikView bug? It crashes with ODBC connection to Informix

[mgavidia]

Hello everyone,

Hopefully someone can help me out with this connectivity problem:

I have setup my ODBC connection to Informix; I've been using with Excel  and Crystal Reports without problems.

This is my setup:

-     Qlikview 11.20 SR2  (Latest QlikView update)

-     IBM Informix ODBC Driver 3.70 TC5DE

-     Windows 7 64-bit

I am now trying to use the same ODBC conenction thru QlikView desktop; the Connection Test is succesful; however, when I click 'Select' in the editor screen to access the tables, Qlikview returns with the following error and aborts the QlikView session.

(I've installed Qlikview Expressor 3.9.1 and the same ODBC connection works fine; I can see the tables in there)

Why is there a problem with QlikView Desktop?

What do I need to do to fix the ODBC connection in QklikView desktop?

Thanks,

Miguel Gavidia

[#2]

Hi Miguel,

I have the same issue, did you get any solution?

[mgavidia]

No, I have not received any answer or tips on what could be the problem.

Just like you, I also e-mailed a couple of users who had similar problems a few months back but they have not reply to me.

I have passed the problem to our QlikView contact support, if I get a solution, I’ll update this post, in the mean time, I am stucked.

Miguel Gavidia

[mgavidia · Accepted solution]

All,

I got the solution to my Informix ODBC connectivity problem from Darren (QlikView).

He sent me this valuable piece of information that worked for me.

Miguel Gavidia

Miguel,

Another company that was having issues connecting QlikView with Informix used an older Informix Driver (2.9)
and was able to connect.  Here are a couple of links to obtain the driver:

http://www14.software.ibm.com/webapp/download/search.jsp?q=&pf=&S_TACT=&S_CMP=&status=Active&sr=1&ca...

http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2011-04-06+21%3A07%3A03.552570R&S_TAC...=