ODBC greyed out

[Tool_Tip]

Dear all,

We are first time trying to create ODBC connection with oracle so we have selected the ODBC from the data connection list but it seems greyed out:

[Tool_Tip]

Something wrong with this?

[Tool_Tip]

[p_verkooijen · Accepted solution]

Hi @Tool_Tip 

The QlikOdbcConnectorPackage is for QlikView. It's embedded in Qlik Sense see help

Setup using Qlik Sense ODBC connector

Create new connection and search for Oracle

Setup using the Oracle driver

If you want to use the Oracle driver and an ODBC connection you have to set it up first in Windows, it only shows existing connections.

To create a ODBC using te Oracle driver you must download and install multiple packages

Go to https://www.oracle.com/nl/database/technologies/instant-client/winx64-64-downloads.html

Choose the correct version and download Base and ODBC Package

• Base - one of these packages is required

  • Basic
  • Basic Light

• Development and Runtime - optional packages

  • ODBC Package

1. Install the Instant Client Basic or Basic Light.
Download Instant Client Basic or Basic Light package and unzip it into the designated directory (e.g. C:\oracle\product). Once the package is unzipped, a new directory with name instantclient_XX_Y (where XX refers the major version and Y refers the minor version of Instant Client)

2. Now unzip the downloaded Instant Client ODBC from the same designated directory where the basic or basic light was unzipped.

Combine the contents of these zip files into 1 folder

3. Execute odbc_install.exe to install the Oracle ODBC driver from the Instant Client directory.

4. Place the tnsnames.ora file in a subfolder C:\OracleDriver\instantclient_XX_Y\network\admin

• https://www.ibm.com/docs/en/tnpm/1.4.4?topic=client-creating-tnsnamesora-file

After this you are able to setup the ODBC connection

Create a System DSN so the ODBC connection is visible for all users.