7 Replies Latest reply: Jul 14, 2016 5:28 PM by Jeremy Latimer RSS

    OLEDB error with Oracle

    Henrique Demarco

      Folks,

      While in 32bits computer this connector works fine. Script was always sucessfully finished.

      OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=gestao;Data Source=plast] (XPassword is xxxx)
      

       

      Now I moved QVW file to a 64bits server with QlikServer and I am getting following error:

      ErrorSource: Microsoft OLE DB Provider for Oracle, ErrorMsg: Error while trying to retrieve text for error ORA-01019

       

      I already installed Oracle OLEBD instead of keep using Microsoft's (as far as I know MSDAORA is deprecated). So I had a new connector string:

      OLEDB CONNECT32 TO [Provider=ORAOLEDB.ORACLE;User ID=gestao;Data Source=plast] (XPassword is xxxx)
      

       

      Using this new provider I got following error:

      ErrorSource: OraOLEDB, ErrorMsg: ORA-12154: TNS:could not resolve the connect identifier specified

       

      How to solve it?

       

      Oracle DB is in Server1 and QlikServer+QVW is in Server2. Can be a connection problem between both?