Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-06-08 08:12 AM

Oracle OLEDB is not working

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

1,005 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2017-06-08 09:10 AM
Author

Oracle OLE DB works fine for me.

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

Maybe a screenshot could help.

678 Views
0 Likes
Not applicable
‎2017-06-08 12:43 PM
Author

In response to Anonymous

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.

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