3 Replies Latest reply: May 17, 2018 2:55 AM by Miguel Angel Baeyens de Arce RSS

    QlikView Connection to Oracle's DB using ODBC

    Manoj K

      Hi Friends,

       

      I am trying to connect Oracle Client using ODBC connection and is working fine. But I am facing issue in loading complete data from database/table. I am getting timeout or system will stop resoponding after getting around 30K records. The particular table is having approx 9L records. My query to database is very straight forward, it doesnot have any conditions or aggregations.

       

      What could be the issue ? Do we need make any changes in connection string or at oracle configuration ?

       

      Is it better to use OLE DB connection than ODBC ?