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
[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.
Hi - Any further help welcomed - I have EXACTLY the same message. Had to go to some trouble to get a 32 Bit ODBC driver for Oracle to use on my 64 bt server but I am using QV10 which offers "Force 32 bit" and when this is ticked my 32 bit ODBC connection appears (it does not if Force 32 bit is not ticked so it is seeing the right ODBC). I get the above message with the username and password which work on the ODBC connection configuration which shows connection successful. How can we identify if this is an Oracle Configuration problem or a Qlikview Problem.
thank you for all of your inputs - I had tried all of the suggestions already - I found out that when downloading Oracle the patches are not downloaded with 10g - in order to recieve the patches they have to be purchased - I uploaded all the latest patches and it is working now. Thanks again for your input.