Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cnallamn
Contributor

Could not find Oracle provider

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

6 Replies

Re: Could not find Oracle provider

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.


talk is cheap, supply exceeds demand
bhagirath
Contributor III

Re: Could not find Oracle provider

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

you can download it from oracle website

Not applicable

Re: Could not find Oracle provider

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

Please mark as correct to help other people if so.

Thanks

@QlikViewer

mov
Esteemed Contributor III

Re: Could not find Oracle provider

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

Not applicable

Re: Could not find Oracle provider

Have you found a solution Chenna?

cnallamn
Contributor

Re: Could not find Oracle provider

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

Community Browser