Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Trying to connect Oracle Database

Hi,

New to QlikSense, trying to connect my Oracle 11g db, using the same steps, as mentioned here:

http://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/2.0/Oracle/Create-Oracl...

But the problem is Oracle ODBC driver is not visible from MS ODBC admin.

Landed to this page: How to create ODBC connection to Oracle

And followed the process to download and tried to install, but instead of 11g, did 12c - is this a problem?

One change, instead of 11g, downloaded 12_2 ODBC driver, these 2 files:

1. Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications

Download instantclient-basic-windows.x64-12.2.0.1.0.zip (75,062,441 bytes) (cksum - 1462971172)

2. Instant Client Package - ODBC Updated 9/20/2017: Additional libraries for enabling ODBC applications

Download instantclient-odbc-windows.x64-12.2.0.1.0-2.zip (804,715 bytes) (cksum - 1844846476)

As mentioned in the steps, created a folder: C:\oracle\instantclient_12_2

Saved both extracted files contents here, but when trying to install, it's giving this msg:

C:\oracle\instantclient_12_2>odbc_install.exe

Oracle ODBC Driver with same name already exists.

And when checking at MS ODBC admin, it's only showing Sql Server, not showing Oracle, please advise/guide, how to fix this problem, or if I'm doing anything wrong here.

Thanks in advance.

Regards

Syed

8 Replies
OmarBenSalem

what if u create the connection as follow:

Capture.PNG

Capture.PNG

Anonymous
Not applicable
Author

Thanks ... when tried this, got this error, please advise:

20180111.png

OmarBenSalem

u have to fill the fields with the right information

Anonymous
Not applicable
Author

the info are all correct, was able to connect using sqlplus.

error msg is about ODBC, do update.

Anonymous
Not applicable
Author

any assistance/update possible? ... still not resolved.

Anonymous
Not applicable
Author

Were you able to solve this? I am at the same situation now...

Anonymous
Not applicable
Author

I've exactly the same pb !

If someone has any update on the subject...