Oracle 11g ODBC connection issue.

[#1]

Any help would be greatly appreciated.

I am trying to setup a qlikview report to be published on a server(Windows Server 2003 x64) using the Qlikview Enterprise Management Console. I am loading my data using an ODBC connection to an Oracle 11g database.  I triple checked to ensure that when I installed the ODBC drivers that I was using  64 bit client software and that the connection was setup using the System DSN. The connection string in the qlikview report is as follows

ODBC CONNECT TO [CONNECTIONNAME;DBQ=CONNECTIONNAME] (XUserId is SOMEHASHKEYSEQUENCE, XPassword is SOMEHASHKEYSEQUENCE);

The weird thing is, if I directly open the report (.qvw file ) on the server using a qlikview developer license the report reloads the data.

If I setup the report on the Qlikview Enterprise Management Console as soon as the date is reloaded it fails.  In the log file for the report I get the following message.

ODBC CONNECT*XUserId*XPassword*

     Error : SQL##f - SSqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I apologize if this has been answered elsewhere.  I could not find another topic with this specific issue.

[danielrozental]

You're probably using a different user for your developer and server reloads.

It might be related to an environment variable or a setting, probably both users have a different ora_home variable or similar.

[#3 · Accepted solution]

This was resolved with a re-install of the Qlikview Enterprise Management Console.