Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview ODBC connection error with Oracle 11g

Hello,

I tried to connect ODBC (Oracle_11g_ODBC_Driver) with Qlikview 10.

I use 64-bit windows for Windows 7; however, Qlikview 10 only allows me to connect ODBC with 32-bit administrator.

Anyway, I got an error msg below:

ErrorCode 12170, ErrorMsg [Oracle][ODBC][Ora]Ora-12170: TNS: Connect timeout occurred.

How can I handle with this problem?

Thanks for your answer in advance.

2 Replies
rbecher
MVP
MVP

Have you tried the 64bit QlikView version? It works great with ODBC/OLEDB and Oracle 11g.

- Ralf

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine
Ferran_Garcia_Pagans
Former Employee
Former Employee

Can you connect from the server to Oracle without Qlikview?

Ora-12170 usually means that database doesn't answer I would first connect from the server to the database without Qlikview to avoid firewall, listener, network and database problems.

Ferran