Oracle OLE DB Connection issue

[devans_1]

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.

[Gysbert_Wassenaar]

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.

[devans_1]

I believe it is installed. I am seeing

Am I missing something ?

[awhitfield]

Are those not ODBC drivers?

Andy

[Gysbert_Wassenaar]

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

[Gysbert_Wassenaar]

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.

[devans_1]

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

[#8]

Thanks bro, it was helpful