Skip to main content
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Test Failed! with "Oracle Provider for OLE DB"

Hi All,

I am using QlikSense desktop v2.1.1 and I am trying to create a new connection in Data Load Editor. I am doing the following:

Create new connection > OLE DB > Provider as 'Oracle Provider for OLE DB' and then entering the credentials in the following format:

Data source (file path or server name) as <hostname>:1521/<service-name>

Then entering the username and password.

But on testing the connection, I am getting a Test Failed.

On the other hand the same details are working just fine in my Oracle SQL Developer.

Any help will be highly appreciated.

Thanks n Regards

3 Replies
Not applicable

Hi All,

I have got the QlikSense to connect to my oracle database using ODBC. I am able to select and load all the tables.

However, I would still like to know how to get the OLE DB to work?

Please advice.


Not applicable

Ohhh..The OLE DB is also working now.

I did not enter the details in the TNSNAMES.ORA file. My mistake.

Case Closed.


Not applicable


I am facing same problem with 12C connection, can you let me know which all details need to be added in tnsnames.ora file?