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:
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=ADE)(CID=(PROGRAM=C:\PROGRA?1\QlikView\Qv.exe)(HOST=SRV01669)(USER=m37401)))(ADDRESS=(PROTOCOL=TCP)(HOST=10.XXX.XXX.XX)(PORT=1521)))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 10.2.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 10.2.0.4.0 - 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
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 10.2.0.4 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:
DBHost:1521/ADE
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 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.XXX.XXX.XX)(PORT = 1521))
)
(CONNECT_DATA =
(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 10.2.0.5 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!
Brgds
Andy
