3 Replies Latest reply: Sep 6, 2013 12:14 AM by D C RSS

    Oracle 10.2.0.5 AIX with Qlikview on Win2008R2 OLE/ODBC Driver Performance Issue

    D C

      Hi,

       

      Just want to find out if anyone has come across this problem and could provide some guidance/suggestions...

       

      We have a client with an Oracle 10.2.0.5 on AIX, and we have a VM installed with Win2008SR2 and QV 11.2SR2.

       

      We have also tried installing the following latest drivers to test from oracle website.

       

           a. Oracle 10g x32 ODAC

        • Success in ODBC Test
        • Fail in QV Connection Test
          • Connection Test Failed

                                    SQL##f- SqlState: IM004, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager]
                                    Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

       

        • Fail in OLE DB Test
          • Unable to allocate memory in the user side

       

           b. Oracle 10g x64 Instant client

        • Success but slow performance (slow means more than 1 day to load 28,000 records)

       

            c. Oracle 11g x32 ODAC

        • Success but slow performance (slow means more than 1 day to load 28,000 records)

       

           d. Oracle 11g x64 ODAC

        • Success but slow performance (slow means more than 1 day to load 28,000 records)

       

      We have another machine with Windows 2003 and we have installed QV on this, and connecting to Oracle with a 32bit driver, and the same extract took less than 3 seconds.

       

      Would anyone have come across similar problem?

       

      I'm guesing its something to do with the ODBC or OLEDB driver at this moment, but Im just guessing, as we have tried whatever we can get our hands on at the moment.. so we are pretty much stuck on how or what we should look at to investigate this problem.

       

      Any advise would be a great.

       

      David