topic Re: QlikView bug? It crashes with ODBC connection to Informix in QlikView

QlikView bug? It crashes with ODBC connection to Informix

mgavidia — Tue, 09 Jul 2013 23:49:14 GMT

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

Re: QlikView bug? It crashes with ODBC connection to Informix

Wed, 31 Jul 2013 13:45:14 GMT

Hi Miguel,

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

Re: QlikView bug? It crashes with ODBC connection to Informix

mgavidia — Wed, 31 Jul 2013 17:29:37 GMT

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

Re: QlikView bug? It crashes with ODBC connection to Informix

mgavidia — Tue, 15 Oct 2013 16:40:02 GMT

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&cat=&q0=&k=ALL&b=&pn=&pid=&rs=ifxdl&fpf=Windows+2000&fdt=&flang=&sb=ra&ibm-go.x=10&ibm-go.y=15

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