Could not find Oracle provider

[Anonymous]

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

[Gysbert_Wassenaar]

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.

[Anonymous]

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

you can download it from oracle website

[#4]

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

Please mark as correct to help other people if so.

Thanks

@QlikViewer

[Anonymous]

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

[#6]

Have you found a solution Chenna?

[Anonymous]

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