10 Replies Latest reply: Sep 8, 2011 2:30 AM by Scott Moon RSS

    Desktop succeeds/ Publisher task fails using Oracle ODBC with TNS-12564

    Andreas Karlsson


      Hi folks,

      While running Qlikview desktop (version 9 SR6) my script can make use of the machines Oracle ODBC-driver without any problem. BUT when Qlikview Publisher (version 9 SR6) executes a task running the very same script it fails!!!!

      The Qlikview document-log which I have enabled just hangs before the very first SQL-statement. There is a SQLNET.txt log created when the publisher fails, it says:



      Fatal NI connect error 12514, connecting to:




      TNS for 64-bit Windows: Version - Production

      Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version - Production

      Time: 15-NOV-2010 14:26:48

      Tracing not turned on.

      Tns error struct:

      ns main err code: 12564

      TNS-12564: Message 12564 not found; No message file for product=NETWORK, facility=TNS

      ns secondary err code: 0

      nt main err code: 0

      nt secondary err code: 0

      nt OS err code: 0


      OK so here is the background information:

      The Publisher machine is a Windows 7 64-bit system and the DB-machine is a 32-bit windows running Oracle 10.2. I installed the 64-bit client software from Oracle ( I had to tweak the oraparam.ini to allow installation on that OS, according to hints in Oracle forums)

      First I installed on my developer machine which is another Win 7 64-bit machine and connected to my developer DB which is an Oracle XE (32-bit). By then I could connect with a connection-string looking like:


      This works on the real Publisher machine as well when running DataDirect 6.1 x64 ODBC-driver. (We don't want to use that driver since it costs 5000€)

      When changing to the Oracle driver instead of Datadirect's I couldn't use that connection-string anymore (got a ORA-12514 error) but had to create a file called OraHome/Network/Admin/tnsnames.ora with a content looking like:


      # TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora

      # Generated by Oracle configuration tools.


      ade.srv01393 =



      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.XXX.XXX.XX)(PORT = 1521))



      (SERVICE_NAME = ade.srv01393)





      By then I could make use of a connection-string looking like ade.srv01393. It works like a charm when testing the connection in the ODBC administrator and when reloading data in Qlikview Desktop but it fails when reloading data in a Publisher task on the very same machine.


      Are there any more files I have to modify other than the tnsnames.ora?

      I also downloaded the 1.1 GB Oracle patch for windows 7 but that could not be installed on just the client software but required the whole DB to be present so never bothered with that since I just want to make use of the ODBC-connection.


      I guess this failure is due to some small configuration that I as a Oracle-newbie has missed.

      Any hints are appreciated very very much!