7 Replies Latest reply: Feb 2, 2011 10:49 AM by claudia_speck RSS

Oracle DB connection issue though Qlikview

I am having difficulty connecting to an Oracle DB though Qlikview. I can create and test an ODBC through the Window Administrator Tools - Data Sources (ODBC) just fine, but when I use that same connection or even try to create a new one through the "edit script" I get the below error.

"Unable to connect

SQLSTate=08004

[Oracle][ODBC][Ora]ORA-12154: TNS:Could not resolve the connect identifier specified"

 

I have even tried an OLE DB connection and have gotten an error with that configuration as well stating: Test connection failed because not all properties can be set - Window Handle (BAD VALUE).

 

I am running the Qlikview client and server V9 - 64 bit on a windows 2003 server OS.

Again I can connect with an ODBC outside of Qlikview just fine. Any hints on how to correct this problem would be appreciated. Thx J.