topic Re: Oracle OLE DB Connection issue in QlikView

Oracle OLE DB Connection issue

devans_1 — Fri, 28 Apr 2017 08:07:16 GMT

Hi All,

I am trying to connect to an Oracle DB via OLE DB. I have Oracle installed and QlikView installed and my understanding is that when I select 'connect' on the edit screen, the connection should be listed. But it isn't. We have other developers with the same setup and it appears for them. Does anyone have any advice on what is wrong ?

Thanks.

Re: Oracle OLE DB Connection issue

Gysbert_Wassenaar — Fri, 28 Apr 2017 09:02:26 GMT

Make sure the Oracle OLEDB driver was installed on your machine. You may need to use the custom install option of the Oracle Client installer to select the OLEDB driver as one of the components that will be installed.

Re: Oracle OLE DB Connection issue

devans_1 — Fri, 28 Apr 2017 09:17:26 GMT

I believe it is installed. I am seeing

Am I missing something ?

Re: Oracle OLE DB Connection issue

awhitfield — Fri, 28 Apr 2017 10:19:10 GMT

Are those not ODBC drivers?

Andy

Re: Oracle OLE DB Connection issue

Gysbert_Wassenaar — Fri, 28 Apr 2017 11:57:49 GMT

Yup, that's the ODBC driver, not the OLEDB driver.

Re: Oracle OLE DB Connection issue

Gysbert_Wassenaar — Fri, 28 Apr 2017 12:05:37 GMT

Try creating a text file and save it with a .udl extension: test.udl. Doubleclick that file and a dialog for editing oledb connections will open. On the Provider tab you should see an item in the list called Oracle Provider for OLE DB. If you don't see that provider listed then you're missing a driver.

Re: Oracle OLE DB Connection issue

devans_1 — Tue, 02 May 2017 12:45:39 GMT

Thanks for your help. Yes, looks like I don't have the driver so I will need to get this from the IT guys....

Re: Oracle OLE DB Connection issue

Thu, 08 Jun 2017 13:55:04 GMT

Thanks bro, it was helpful