Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mgavidia
Contributor

QlikView bug? It crashes with ODBC connection to Informix

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

Image-0286.png

1 Solution

Accepted Solutions
mgavidia
Contributor

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

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...=

3 Replies
Not applicable

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

Hi Miguel,

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

mgavidia
Contributor

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

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
Contributor

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

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...=

Community Browser