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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-01-26 06:22 PM

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,961 Views
0 Likes
2 Replies
rbecher
MVP
MVP
‎2012-01-27 03:50 AM

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
763 Views
0 Likes
Ferran_Garcia_Pagans
Former Employee
Former Employee
‎2012-01-27 04:14 AM

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

763 Views
0 Likes