topic Re: Could not find Oracle provider in Visualization and Usability

Could not find Oracle provider

Anonymous — Tue, 07 Apr 2015 12:19:43 GMT

Hi All,

I have a QVF file imported into QS hub and wanted to create a Oracle connection string. I have installed Oracle client in the server where QS server is installed and I have my TNSNames file updated with proper connection strings.

I am unable to find the provider "Oracle provider for OLEDB" though Oracle client is installed. (Attached screenshot for reference)

Can you please advise what could be the issue here.

Thank you.

Regards,

Chenna

Re: Could not find Oracle provider

Gysbert_Wassenaar — Tue, 07 Apr 2015 12:29:37 GMT

Installing the Oracle Client doesn't always mean you also installed the OLEDB provider. It depends on the type of installation you did. Try the Custom install option to check if the OLEDB provider is already installed and add it if it wasn't.

Re: Could not find Oracle provider

Anonymous — Tue, 07 Apr 2015 12:50:03 GMT

the best way is Get ODAC (Oracle Data Access Components) this surely contains oledb provider.

you can download it from oracle website

Re: Could not find Oracle provider

Tue, 07 Apr 2015 13:39:32 GMT

Hi. Here are some detailed instructions you can use. Hope it helps.

Please mark as correct to help other people if so.

Thanks

@QlikViewer

Re: Could not find Oracle provider

Anonymous — Tue, 07 Apr 2015 14:23:56 GMT

Does it change if you check/uncheck "Force 32 bit"?

Re: Could not find Oracle provider

Tue, 07 Apr 2015 21:47:22 GMT

Have you found a solution Chenna?

Re: Could not find Oracle provider

Anonymous — Tue, 14 Apr 2015 09:50:01 GMT

Hi All,

We were able to solve this by installing another instance of Oracle 11. there was some issue with the earlier oracle software.

Regards,

Chenna