topic Re: Oracle OLEDB is not working in Management & Governance

Oracle OLEDB is not working

Thu, 08 Jun 2017 12:12:09 GMT

Hi All,

We are facing strange problem in QlikSense, our Oracle OLE DB connection is not working, while testing connection it fails in data connection wizard, however if we create ODBC DSN, we are able to access using ODBC

ODBC is very slow, and we want to test out OLE DB once, please help us.

Regards,

Navdeep

Re: Oracle OLEDB is not working

Anonymous — Thu, 08 Jun 2017 13:10:01 GMT

Oracle OLE DB works fine for me.

Could you elaborate on what kind of "not working" you are getting ?

Maybe a screenshot could help.

Re: Oracle OLEDB is not working

Thu, 08 Jun 2017 16:43:14 GMT

Hey Bill,

Thanks a lot for the response, I got it working with adding database detail in tnsnames.ora file, below are the steps, may be helpful for other users

I was able to do it, Steps for installation.

Download Oracle Client GUI version from Oracle website
Download ODAC from Oracle website
Install using setup.exe with all general properties
Open Net Manager and add tsn
Restart the server and it should start showing up under providers 'Oracle for OLE DB'
Make Connection and it should work