Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
New to QlikSense, trying to connect my Oracle 11g db, using the same steps, as mentioned here:
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
what if u create the connection as follow:
Thanks ... when tried this, got this error, please advise:
u have to fill the fields with the right information
the info are all correct, was able to connect using sqlplus.
error msg is about ODBC, do update.
any assistance/update possible? ... still not resolved.
Were you able to solve this? I am at the same situation now...
I've exactly the same pb !
If someone has any update on the subject...
I solved the following steps.