Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sean_BI
Creator
Creator

Error in ODBC Connection

Dear Experts -

I truly need assistance here. 

The version of QV desktop is 12 with enterprise edition license. When connecting ODBC from script editor, it results in TNS timeout error. 

The Oracle 11 g Home1 edition client and drivers are installed. TNS entries are made correctly, system DSN is created and the connection is successful. But, when trying to connect form qv script editor results in TNS time out error and application hangs. 

Troubleshoot that i've done is - 

1. Verified the TNS entries in the tns.ora file located in oracle client installed drive... network\admin\

2. Verified the sqlnet entries in the client installed drive... network\admin\ 

3. Reinstalled the qlikview personal edition and licence edition as well. 

4. Able to telnet the DB server IP id and host as well where in target host is available and is listening successfully.

5. Able to successfully ping the DB server IP id as well.

Appreciate any response soon. 

Pls, note i am successfully able to connect to hadoop with Impala drivers v2.5, but can't get thru Oracle connection.

Thanks, 

Sean.

 

 

1 Reply
NadiaB
Support
Support

HI @Sean_BI 

Please refer to the following article:

Installing the Full Oracle OLEDB & ODBC Drivers for Qlik Products

Best Regards.

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm