3 Replies Latest reply: Mar 30, 2016 6:42 AM by kushal chawda RSS

    DIRECT QUERY ORACLE OLEDB CONNECTION AND SYSTEM REQUIREMENTS

    Avinash Jain

      DEar Team,

       

      I am getting connected with Oracle insome machine from Qlikview with below connection:

       

      OLEDB CONNECT32 TO [Provider=MSDAORA.1;Password=ido;User ID=ido;Data Source="HOSTNAME/SERVICENAME"];

       

      AND IN SOME MACHINE WITH ONLY:

      OLEDB CONNECT32 TO [Provider=MSDAORA.1;Password=ido;User ID=ido;Data Source=""SERVICENAME""];

       

       

      In client environment we are truing to generatereport WITH direct query.

       

      Can you please advise what are the requirements to set up OLEDB CONNECTION SUCCESSFULLY and which string should I use?

       

      Do we really nned to have ORACLE CLIENT ON QLIKVIEW SERVER MACHINE?

       

      Please guide.